[AccessD] Friday Puzzler - Access 2007 - "Report View" "On Format" and "On Paint" Events

Brad Marks BradM at blackforestltd.com
Fri Oct 29 14:41:46 CDT 2010


When using “Report View” in Access 2007, the “On Format” event is not fired (we need to use “Report View” features).

The “On Paint” event, however, is fired.

In the “On Paint” Event
Me.Box1.BackColor = vbBlue
Works nicely


However the command
Me.Box1.Width = 1000
issues the message “The setting you entered isn’t valid for this property”, although this exact command will work with a test button.

Is there a way to resolve this?  I would guess that other Access 2007 users have run into similar issues with Report View.

Thanks,
Brad  




More information about the AccessD mailing list