Amount Display

[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

 

[Guest]

Hi,

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

Jim

 

[John Vinson]

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

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]

 

[Guest]

Thank you both for your replies...

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]