Special Effect - Text Box

[Suzie Raboin]

Hello,

I'm running into trouble using the special effect feature on my text boxes.
I recently created a new database and in the creation of my forms realized
that all of the text boxes looked as though they had the "flat" special
effect even though under properties it says that they have a special effect
of "sunken". I have to go into the properties on each text box and click
through all of the special effect options before it will appear as sunken.

I tried reinstalling Access (2003) but the problem was not fixed. Does
anyone have any suggestions? Also, this has not been a problem in any of the
other databases I have developed.

Thanks,
Suzie

 

[Tom Wickerath]

Hi Suzie,

Not sure, but it sounds like your form might have some corruption in it. You
can try using the undocumented SaveAsText / LoadFromText methods to see if
this helps. First, make a back-up copy of your database. Then try issueing
the following command from the Immediate (Ctrl G) Window:

application.saveastext acForm, "NameOfForm", "C:\temp\NameOfForm"

Rename the form in question and compact the database. Then issue the
opposite command to try to restore your form:

application.loadfromtext acForm, "NameOfForm", "C:\temp\NameOfForm"


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Albert D. Kallal]

Perhaps you have themes turned on....

Take a look at the following screen shots:

http://www.members.shaw.ca/AlbertKallal/Atheme/index.htm

Note how the "sunken" setting is ignored on the themed screens.

however, I still think they look way better, and it makes your old tired
software look much more up to date...

If you want that 10 year older look, then change the settings in ms-access
to turn off themes:

tools->options->forms/reprots


[x] Use Windows Themed contorls on Forms <--- uncheck this option...

 

[Suzie Raboin]

Thanks to both of you for your help on this. It was the themes that was
causing the problem. All is well for now. Thanks again!