S
Steven
I have a list box where the record source is a query. One
of the fields I want in the list box is an amount field
with 2 decimal places. In the list box this field does
not show the 2 decimal places but rounds to the nearest
whole dollar. I dont want to say Str(Amount) in the query
because the query is also populating another field in the
form. Is there a way I can show the decimal places in the
list box without using Str(Amount) in the query.
Thank you for your help.
of the fields I want in the list box is an amount field
with 2 decimal places. In the list box this field does
not show the 2 decimal places but rounds to the nearest
whole dollar. I dont want to say Str(Amount) in the query
because the query is also populating another field in the
form. Is there a way I can show the decimal places in the
list box without using Str(Amount) in the query.
Thank you for your help.