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

VB for Access

ResolvedVersion 2003

Fri 28 Nov 2008, 11:28 Delegate 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

Mon 1 Dec 2008, 09:54 Trainer 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.

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

VB for Access

VB for Access

RE: VB for Access

Access articles

Access tip:

Hiding Multiple Table columns