Date displaying

[Russ]

I've got a report that puts dates at the top of columns and the user
is prompted to enter a beginning date when the report is opened. That
date is put in a textbox in the first column like this:

=DateValue([Enter 1st date to display - Ex: 1/5/03])

Then the next columns are textboxes that add 7 to the previous column
for the date display of the next week like this:

=[Text12]+7

This goes for a six month period.

The problem is sometimes the report will not display the first half of
the 6 months, and I have to fix it by cutting the columns that are not
displaying and pasting them back into the report. Is there another
way I can display these dates to *possibly* avoid this problem?

Russ

[Allen Browne]

Russ, the crucial thing is to ensure Access understands the data type.

Base the report on a query, and declare the parameter in the query
(Parameters on Query menu in query design). This way you can specify that it
is a Date/Time type.

In the report, set the Format property of the text boxes to:
Short Date
or similar. This way, Access knows the intended data type.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Russ" <Ru***@notathome.com> wrote in message
news:4c********************************@4ax.com...

I've got a report that puts dates at the top of columns and the user
is prompted to enter a beginning date when the report is opened. That
date is put in a textbox in the first column like this:

=DateValue([Enter 1st date to display - Ex: 1/5/03])

Then the next columns are textboxes that add 7 to the previous column
for the date display of the next week like this:

=[Text12]+7

This goes for a six month period.

The problem is sometimes the report will not display the first half of
the 6 months, and I have to fix it by cutting the columns that are not
displaying and pasting them back into the report. Is there another
way I can display these dates to *possibly* avoid this problem?

Russ

[Russ]

Allen,

I've set the format of the text boxes to date as you suggested, but
for now I am going to get the input when the report runs, not when the
query runs. If it happens again, I'll work on the query. This
approach doesn't seem to be headed in the right direction however,
because the last 6 months of dates always works just fine.

Russ

On Sun, 14 Sep 2003 15:49:08 GMT, "Allen Browne"
<ab***************@bigpond.net.au> wrote:

Russ, the crucial thing is to ensure Access understands the data type.

Base the report on a query, and declare the parameter in the query
(Parameters on Query menu in query design). This way you can specify that it
is a Date/Time type.

In the report, set the Format property of the text boxes to:
Short Date
or similar. This way, Access knows the intended data type.