Format$

[DebK]

I just converted a 2003 .mdb over to 2007 .accdb and now when I try to run
some reports I have I get a message saying Enter Parameter Value for Format$.
I rebuilt the report based off a query using the report wizard and still get
the message and #Error in the field on the report itself. This is what I
have for the control source =Format$([Timestamp],"mmm yyyy"). Can anyone
help?

 

[Cheese_whiz]

Hi Deb,

Not sure I understand why you have that dollar sign in there right after the
word (function) 'Format'.

I'd take it out and give it a try. Could that 'format$' be some modified
'format' function that requires a reference, or requires a module that wasn't
quite converted properly?

HTH,
CW

 

[Dirk Goldgar]

I just converted a 2003 .mdb over to 2007 .accdb and now when I try to run
some reports I have I get a message saying Enter Parameter Value for
Format$.
I rebuilt the report based off a query using the report wizard and still
get
the message and #Error in the field on the report itself. This is what I
have for the control source =Format$([Timestamp],"mmm yyyy"). Can anyone
help?

By default, Access 2007 disables VBA code in databases as a security
measure, and Format() is a VBA function. Try putting your database in a
trusted location (as specified through the security center), or explicitly
trusting it. It may also be necessary to set macro security to low. I'm
not sure