Prompting for a Date

[wal50]

I need to prompt for a date that would be added to the report header. The
date would not be part of any of the records or select criteria - just a
label - like "data good until mm/dd/yyyy".

Thanks,

wal50

 

[Allen Browne]

Set the control source of the text box to something that is NOT a field
name, e.g.:
=[Enter a date]

 

[Hansford cornett]

Place the following code in your report if all you are wanting to do is place
this date into the report:

Data Good Until: [DataGoodUntil (mm/dd/yyyy)] this will cause the report to
ask for the report every time it is run however it will not save this date.
The format prompt is only recommended. Slashes must be input unless you set
the property in the field on the report under mask to Short Date or what ever
date format you desire.

 

[wal50]

That was easy. Thanks for your help.

wal50

Set the control source of the text box to something that is NOT a field
name, e.g.:
=[Enter a date]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I need to prompt for a date that would be added to the report header. The
date would not be part of any of the records or select criteria - just a
label - like "data good until mm/dd/yyyy".

Thanks,

wal50

 

[isanchez2769]

I have the report asking for a value "What Trailer?" To know what
trailer I want to use I need to know the box count.
The report gets the data from a query, in the query is a field that tells
me how many boxes each delivery has, is there a way to have the sum
of the boxes show up with the "=[What Trailer?]" prompt?

Isaac

Place the following code in your report if all you are wanting to do is place
this date into the report:

Data Good Until: [DataGoodUntil (mm/dd/yyyy)] this will cause the report to
ask for the report every time it is run however it will not save this date.
The format prompt is only recommended. Slashes must be input unless you set
the property in the field on the report under mask to Short Date or what ever
date format you desire.

I need to prompt for a date that would be added to the report header. The
date would not be part of any of the records or select criteria - just a
label - like "data good until mm/dd/yyyy".

Thanks,

wal50