Data Type currency

  • Thread starter Thread starter 1aae
  • Start date Start date
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
 
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?
 
thank you
Is there any way to pervent displaying $ beside the number in table or a
form?
and use (Currency Data Type)?
Thank you
Click to expand...

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.
 
Back
Top