Currency Format

[mousemat]

Hi all

I have an unbound form containing textfields that are populated on the afterupdate event of the combo box.

The combobox is driven by a query which among other things contains a currency value. When I run the query, the format of the field is correct (£23.00) however, when I use the combobox to populate the form, only the number populates the textfield (23) The textfield is set for currency however, I can't seem to get it to show the correct formatting.

How can I resolve this issue?

 

[Simon_MT]

I not sure if this will work. but I had the same problem, in Access 2007 in the Table there is Text Align on the field Property. I set that to right and then remove any formatting features in the Query. I have problems with this since 1997.

Simon

 

[mousemat]

Hi Simon

Thanks for that, however it hasn't made any differance.
I'll keep googling

 

[mousemat]

Ok

Having googled and search this forum, I have now found the answer to my problem

RoyVidar
Registered User

Join Date: Sep 2000
Location: Norway
Posts: 805
Thanks: 0
Thanked 1 Time in 1 Post

Try make the controlsource

=Val(theCombo.column(5))

in stead of

=theCombo.column(5))

See, anything but the bound column, I think, is considered text, so I think you need to convert it to numeric.
__________________
Roy-Vidar