Currency Formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello: I have a query that has fields that are formatted as currency. I am
using a control source to select data from the query and populate textboxes
on a form. The values were copied correctly but without the currency
symbols... any suggestions?

thank you.
 
You can do this 2 ways. One is to create the control by dragging it
off of the Field Box (View Menu->Field List in Design View). It
"Should" carry over the formating conditions of the field in the
Database. If it doesn't, select the text box in design view and
manually set the Format property under the Format tab of the properties
sheet to Currency.

Hope this helps
 
I am still encountering the same problem. I tried both ways. If i use an
unbounded textbox everything works fine, i guess the problem is due to the
fact that the other texboxes are bound. But the values that i am using from
the query are formatted as currency so why is this a problem?

Thanks for your help.
 
Back
Top