Amount Display

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

Guest

Is there a way to display an amount number with comma separated. When the
data is entered it displays properly, but if you do a query the results are
displayed without the commas. I tried using the input mask to no avail as
well as the format mask. I really want a standard number with commas and no
decimals. ex, 500000 should display as 500,000 or in the same field 5000000
should display as 5,000,000
 
Hi,

From the query design view, right click on the field and select
Properties..., and set the format to the type you want.

Jim
 
Is there a way to display an amount number with comma separated. When the
data is entered it displays properly, but if you do a query the results are
displayed without the commas. I tried using the input mask to no avail as
well as the format mask. I really want a standard number with commas and no
decimals. ex, 500000 should display as 500,000 or in the same field 5000000
should display as 5,000,000
Click to expand...

I'd strongly suggest simply using a Form to display your amounts (or
use a Report to print them). Base the Form on your query, and set the
format of the form (or report) textbox appropriately. Query datasheets
aren't really designed for display of data!

John W. Vinson[MVP]
 
Thank you both for your replies...

John Vinson said:
I'd strongly suggest simply using a Form to display your amounts (or
use a Report to print them). Base the Form on your query, and set the
format of the form (or report) textbox appropriately. Query datasheets
aren't really designed for display of data!

John W. Vinson[MVP]
Click to expand...
 
Back
Top