Unable to Format Bound Text Box as Currency

[froadie]

Hi,

I have a text box that was formatted as currency. However, when I bound it to a field, it lost the formatting. When I go to Format in the Properties box and click the dropdown list, there are no longer any format options available. I'm facing this problem with several different text boxes. Is there any way to get that formatting back? Or any other way to format a bound text box as currency?

 

[Kryst51]

Is your field a text field or a currency field. If your bound field is a text field you can't format it as currency. You have to change your field type to number.

 

[froadie]

It's a bigint

 

[Kryst51]

Is your field formatted as currency?

 

[froadie]

In the database? No. I wanted to do it only in the text box, for display purposes

 

[Kryst51]

Is your table in SQL? Because I tried it with Access, long integer, and it works fine.

 

[froadie]

Yes, it's a sql table, bigint data type

 

[Kryst51]

Froadie, I'm sorry, I don't have an answer for you, I don't know anything about how SQL works with Access. I thought this was an Access only issue.

I am sure other people will chime in though, who might be able to provide some insight.

 

[boblarson]

If the data type in SQL Server is MONEY then it formats automatically to currency in Access withOUT additional formatting (at least for me - Access 2003 / SQL Server 2005)

 

[dcb]

Have you tried a type conversion using CCur() in your underlying query (on the access side)