access 2010 date field

[fhsmith]

I have a report made in access 2010. It has a date field that is
formated as short date. When reviewing the report in print preview,
the date field displays ####### instead of the date. However, when I
click on the date field, the correct date appears.

How do I resolve this? Any assistance is appreciated.

 

[Gene Wirchenko]

I have a report made in access 2010. It has a date field that is
formated as short date. When reviewing the report in print preview,
the date field displays ####### instead of the date. However, when I
click on the date field, the correct date appears.

How do I resolve this? Any assistance is appreciated.

I think that you did not allow enough room for the date. Widen
the field.

Sincerely,

Gene Wirchenko

 

[fhsmith]

     I think that you did not allow enough room for the date.  Widen
the field.

Sincerely,

Gene Wirchenko

Your were right Gene, I adjusted the field's length and all works fine
now. Thanks for your reply.

 

[Gene Wirchenko]

[snip]

Your were right Gene, I adjusted the field's length and all works fine
now. Thanks for your reply.

You are welcome.

Sincerely,

Gene Wirchenko

 

[David]

I assume you are looking at it in 'Report View'. It sounds like the field is too narrow, try changing in 'Design' mode' to 0.85" to 0.9" to allow room for short dates. Then look at the report in 'Preview' form, it should be ok.