how do I enable font/fore color in runtime?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to develop a program in MS Access 2003 and I need to enable the
formatting tools in the runtime environment so they will be enabled when the
program is distributed to users who do not have Access on their pc's.

The ones I need are Font/Fore Color, Bold, Underline, Center, Align Left,
Align Right, Line/Border Color etc:

I cannot seem to find code that will do this for me. I have created a
custom menu and placed them under a "Format" drop down object.

When I open the program in runtime, all these are grayed out.

Please help as I have been working on this one problem for about a month now
.. I cannot seem to find the answer to this problem anywhere. I found an
article on the Microsoft page (Article 198464) but that is for Access 2000
and I cannot get it to work for what I want.

Any and all help will be GREATLY appreciated.

Thank you.
 
If you just want to do formatting programmatically, then there should be no
problem; however, if you are saying you want the user to be able to apply
these kinds of formatting options, you can't.
 
Klatuu,

Nictuu.

Thank you. Especially for the quick response.

I just want to allow the user to change the font in a text box, be able to
bold it if he wants to, change the color, and so on. I guess this is not
possible then, in Access except in the Access environment and not in runtime.
 
Well, I guess you actually could, but it would be a dental procedure without
pain medication.
You could write VBA code that would allow them to do it. You would have to
provide the interface, get what they want to do, and do it in code, but that
may not be feasible.

You also might browse through this site : http://www.lebans.com/
Steven Lebans is probably the best there is when it comes to formatting
tricks.
 
Back
Top