I have several reports that use the date function. They have worked up until yesterday. Now when the report loads, I get a prompt for "date" and "format" as if it were a parameter query.

I have tried deleting the date textboxes and re-adding them, and Access still seems to think it is a parameter query. I have used both "insert" to add the date, and have even created the calculated text box myself, but it still acts like a parameter query and promts the user for the format and date. Interestingly the "now" function works fine. I've compiled, and compact/repaired with no change in results.
1) Does anyone have any other ideas of how to fix this?

Thanks!
Loralee

check your record source for the reports and make sure there are no missing references or tables in the query itself. Some food for thought

Unfortunately, that is all intact. And the queries run fine on their own in QBE.

It appears VB may have lost it's reference to the functions Format and Date???? These are the 2 "parameters" it is asking for.

If you havent solved this yet...

I would test out your date and format functionality by throwing them into a basic select query and see what comes out. Unless you have much bigger problems, cant imagine you would just lose a built-in function.

Assuming you can use them and further to bjackman's suggestion... you may want to check out all the "hidden" (I know they arent actually hidden, but I mean the non-body text bit!) parts of your report, like groupings, all properties etc, have done similar in the past before... from the sound of it, there may be a "[date]", rather than "=date()" knocking about in there somewhere, Access does do that kind of thing if you havent entered it initially correctly... pain in the derriere, get a colleague to help spot it... had to sort this kind of thing out before when removing fields from a source query and then realising they were used in one of the groupings or similar.

Good luck, they can be tricky to spot.

Thanks, Lee (and bjackman),
I tried running each query again, and they run fine. I checked Properties, and Groupings, etc. and found nothing unusual. Still none of format or date functions work. Even on a newly created Report. And some of the calculated text boxes that had working concantenations are not working now. Now() still works. I think I've got a big problem.
Any other suggestions??

Thank you,

Loralee

k, start a new mdb and try it out with that... failing that, err... reinstall Office?

I have come across similar but not the same in the past when not realising I was sat in a breakpoint of some code... far out suggestion, but make sure you arent sat in a breakpoint of some code!

The .mdb must have corrupted somehow......
I ended up taking a backed-up copy of the .MDB, removed the older tables, and imported a copy of the tables from the broken .mdb that had the malfunctioning textboxes. So far it's working fine and the textboxes are behaving. I can't wait to just split the thing.

Thanks,
Loralee