date pulled from the date report

zxmax

Registered User.
Local time
Today, 14:20
Joined
Mar 14, 2004
Messages
16
Here is my scenario:
I have a form called "Date Range" which has 2 unbound feilds , i use this as a popup Form throught my database when i want to print my report, so i could filter specific date, this part works just fine,

On one of my reports, "end of year report" i want to show the date slected by the user in the "date Range" entered .. is there any i could do that, since these dates are not stored anywhere ?

I hope i was clear explaining my problem.. Thanks in adavance
 
Put two text boxes on the report. In their Control Source, reference the respective control on the form e.g.

=[Forms]![Date Range]![TextboxName]


The form must be open when the report is run.
 
Perfect works great,

Now i have very very minor problem, the date now is showing in this format 1/2/2004 in the report, now i would like to change the it to 1 Feb 2004 , Note, that i DID change the input Mast in the FrmDate ,, i looked in the unbound properties but there is no option for Input mast , or date formate , since its an unbound box,

Thanks again for the great support
 
zxmax said:
... i would like to change the it to 1 Feb 2004

in the Format section of the text box, change the format to d mmm yyyy
 

Users who are viewing this thread

Back
Top Bottom