Decimals

[rjfm]

Help!

I set up a table - however when I want to print out a report it will not
include the zeros after the decimal if there is no value such as

14.00 comes out like 14.
14.20 comes out like14.2

I want my data to come out the same overall and look like the data below
14.22
14.20
14.00

rjfm

 

[Steve]

Open your report in design view and select the field. Open properties and go
to the Format tab. Set the format to ##.00.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[John W. Vinson]

Help!

I set up a table - however when I want to print out a report it will not
include the zeros after the decimal if there is no value such as

14.00 comes out like 14.
14.20 comes out like14.2

I want my data to come out the same overall and look like the data below
14.22
14.20
14.00

rjfm

Set the Format property of the textbox for this field to

#.00

John W. Vinson [MVP]