Unbound textbox won't appear as currency

[Guest]

Hi

The primary key on my form is a combobox which has three colums. I have an
unbound textbox that takes it's value from one of the colums - this works but
the value it takes is a currency values. The Unbound textbox is formatted as
currnecy but the number is displayed unformatted. Why is this and how can it
be resolved?

 

[Arvin Meyer [MVP]]

To be sure, I just check the behavior of unbound textboxes in several
versions of Access. If the Format property of the combo is set to "Currency"
all values take on the currency format. It may be that your Windows Regional
settings in the Control Panel are not defining what currency is.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

thanks for the response. I am on a networked PC - the setting look set for UK
currency though but I'll check it on my PC later.

the expression I used in the unbound textbox was =ProdCode.column(3).

When I have used currency within other tables it has worked fine.

 

[Guest]

I have now tried it on a PC that has the correct currency/local settings.
Even when I click on the prodcode combo box the column is there as a monetry
value but it just isn't formatted as currency in the unbound box. First I
forgot to format the box so did so after I entered the expression and I tried
it again recreating the box - setting to currency then entering the
expression but it didn't work.

JM

 

[Arvin Meyer [MVP]]

If that's the case, you have a corrupted form or a flawed install of either
Office/Access or Windows. Try building another simple form with only a
textbox. You might also try formatting currency in Excel to see if the
problem is more extensive.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access