vb access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » VB for Access

VB for Access

resolvedResolved · Low Priority · Version 2003

replyReply Fri 28 Nov 2008, 11:28Delegate Graham said...

Graham has attended:
Access Consulting course

VB for Access

Can you use VB code to directly and programatically change the currency symbol on one or more currency fields in a data table/form. For example I would like to have the currency symbol change automatically when I switch between

For upcoming training course dates see: Pricing & availability

replyReply Mon 1 Dec 2008, 09:54Trainer Stephen said...

RE: VB for Access

Hi graham

Thank you for your question

You can programmatically set the specific currency for a text box by placing the symbol directly in the format property of the text box.

The following line of code sets the currency symbol to sterling.

Me.TextBox.Format = "

Mon 8 Dec 2008: Automatically marked as resolved.

 

Please browse our web site to find out more about
access database course and other Microsoft training courses.

Access tip:

Insert The Current Date

To insert the current date into a Table field or Form Text box use:

Ctrl+Semi-Colon(;)

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard