Access 2003. Split database.
Can I set the Font Name/size/colour of a control in a report from a form.
The form would not be open when the report was run.
I want to give individual users the ability to set these within Reports
based on what is comfortable for them to read. I think I could do this by
having a local table on the Front end but other than that don't know. Any
suggestions?

If you've got exclusive access to the database, when the form is open, you
could open the report in design mode, set the font information
appropriately, then save the modified report. Other than that, the form
would have to be open in order for the report to be able to "read" the
values from it and modify itself.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Simon" <(E-Mail Removed)> wrote in message
news:6B931279-71A2-40DB-89B4-(E-Mail Removed)...
> Access 2003. Split database.
> Can I set the Font Name/size/colour of a control in a report from a form.
> The form would not be open when the report was run.
> I want to give individual users the ability to set these within Reports
> based on what is comfortable for them to read. I think I could do this by
> having a local table on the Front end but other than that don't know. Any
> suggestions?