Data Type currency

1

1aae

thank you
Is there any way to pervent displaying $ beside the number in table or a
form?
and use (Currency Data Type)?
Thank you
 
D

Duane Hookom

The format property of a text box on a form or report is independent of the
data type in the table. Have you tried setting the Format property to
Standard and Decimal to 2?
 
J

John Vinson

thank you
Is there any way to pervent displaying $ beside the number in table or a
form?
and use (Currency Data Type)?
Thank you

Sure; just set the Format property of the field to a numeric format
rather than to the default Currency format. The format and the
datatype are independent.

For instance, a format of # will show the value as 3324.0813.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top