Hello Everyone,
This is my first post.
I have hunted help pages and forums for months looking for a solution to this baffling nuisance.
I have a pretty simple database which includes a form with several fields which contain equations/functions/expressions. (They start with =).
It also has some fields which have conditional formatting.
I have been using this form for years and this problem has only appeared comparatively recently.
I open the database with a homemade shortcut which then opens the form. This is when the problem arises.
The form opens, but all the expressions look like this <<#Name?>> and none of the conditional formatting is applied.
Now here it gets stranger.
I open the form in ‘Design View’. Select ANY one of the fields with an expression.
Select ‘Properties’
Go to ‘Control Source’
Right Click and choose ‘Zoom’
CHANGE NOTHING
Close the window. Go to ‘Form View’
Everything works. All expressions and formatting now O.K.
Can anyone tell me what is wrong and how I can fix it.
Thank you.
V
This is my first post.
I have hunted help pages and forums for months looking for a solution to this baffling nuisance.
I have a pretty simple database which includes a form with several fields which contain equations/functions/expressions. (They start with =).
It also has some fields which have conditional formatting.
I have been using this form for years and this problem has only appeared comparatively recently.
I open the database with a homemade shortcut which then opens the form. This is when the problem arises.
The form opens, but all the expressions look like this <<#Name?>> and none of the conditional formatting is applied.
Now here it gets stranger.
I open the form in ‘Design View’. Select ANY one of the fields with an expression.
Select ‘Properties’
Go to ‘Control Source’
Right Click and choose ‘Zoom’
CHANGE NOTHING
Close the window. Go to ‘Form View’
Everything works. All expressions and formatting now O.K.
Can anyone tell me what is wrong and how I can fix it.
Thank you.
V
)
