Full Version: Using Form
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
jtwork
Not sure why this has happened but this has been working for weeks and now i have a problem.

I have a form which i input a from and to date

[forms]![frm_report]![from]
[forms]![frm_report]![to]

I used these values in my query as expressions so i would know what date the data was for

Date_From: [forms]![frm_report]![from]
etc

Now they are appearing blank. I have tried changing the text box format from short date to blank (text) and this seems to sort the problem but i would like it as short date, it worked beore so not sure why not now.
strive4peace
since values in TEXTboxes are, well, text... try wrapping the control reference in a date conversion function

DateValue([forms]![frm_report]![from])
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.