Rounded #'s

[Guest]

Hello,

Within one table, I created a "lookup" field pulling from another table.
The table that is the lookup includes three columns. The data that I am
displaying is the third coulmn - a dollar amount. For example, complex,
facility, costs. I am able to have the third coulmn display the costs but it
rounds it and doesn't show the "$".

I have tried changing everything in all areas but can't seem to make it
work. Any help would be great.

Thanks.

 

[Guest]

Try formatting the costs column in the column's RowSource query by changing
the reference to the column in the RowSource property from something like
YourTable.Costs to Format(YourTable.Costs,"Currency").

If you are doing this in table design view rather than in a control on a
bound form you'll find the RowSource property on the Look Up tab of the
column's properties sheet. Note however that if you have previously created
a form based on the table the RowSource of any combo box bound to the field
on the form won't automatically change if you change it in table design.
You'd need to change the property of the combo box on the form as well.

Ken Sheridan
Stafford, England