the user's input
If it is not from a table then where is it from?
If it is text instead of a DateTime datatype you might use this, that is if
the text is in a format that Access will recognize as a date --
Format(CVDate([User_Input]), "Long Date")
--
Build a little, test a little.
Tim said:
Thank you both of you.
Karl, I did do exactly the same thing as you showed to format the long date
in the Query. I also go to the Report and at the date's text field, I format
long date also. But it still just show up the short date. BTW, this field
date is NOT in the database's table, I just capture it from the user's input
and want to display it as Long date. Pls advice. Thx.