John
It sounds to me like the form might be partially corrupt.
First make a backup of your database.
Press Ctrl+G to open the Immediate window. Type:
SaveAsText acForm, "YourFormName", "C:\YourFolderName\YourFormName.txt"
Press Enter. That will save the form as text. This also usually cleans up any minor corruption.
Delete the form in the database and compact.
In the Immediate window, type:
LoadFromText acForm, "YourFormName", "C:\YourFolderName\YourFormName.txt"
Compact and check the conditional formatting to see if it is working. If it isn't decompile the database following the instructions at www.fmsinc.com/microsoftaccess/performance/decompile.asp
Bill
---In MS_Access_Professionals@yahoogroups.com, <shelbysalpha@yahoo.com> wrote :
From: "wrmosca@comcast.net" <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, March 21, 2014 1:40 PM
Subject: Re: [MS_AccessPros] Re: Continuous form conditional format
---In MS_Access_Professionals@yahoogroups.com, <shelbysalpha@yahoo.com> wrote :
No I am not creating a web app. That is what fixes the problem.
."The only real mistake is the one from which we learn nothing."
John Powell (1834-1902)
John Powell (1834-1902)
"Patience is the companion of wisdom."
Saint Augustine (354 AD - 430 AD)
Saint Augustine (354 AD - 430 AD)
"Success is the ability to go from one failure
to another with no loss of enthusiasm."
Sir Winston Churchill (1874 - 1965)
to another with no loss of enthusiasm."
Sir Winston Churchill (1874 - 1965)
From: "wrmosca@comcast.net" <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, March 21, 2014 1:40 PM
Subject: Re: [MS_AccessPros] Re: Continuous form conditional format
John
So you are creating an Access web application? Lots of things don't work in those. Maybe someday MS will get it right.
-Bill
---In MS_Access_Professionals@yahoogroups.com, <shelbysalpha@yahoo.com> wrote :
From: "wrmosca@comcast.net" <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, March 21, 2014 10:33 AM
Subject: [MS_AccessPros] Re: Continuous form conditional format
---In MS_Access_Professionals@yahoogroups.com, <shelbysalpha@yahoo.com> wrote :
---In MS_Access_Professionals@yahoogroups.com, <shelbysalpha@yahoo.com> wrote :
---In MS_Access_Professionals@yahoogroups.com, <shelbysalpha@yahoo.com> wrote :
Bill,
File-> Save & Publish-> Publish to Access Services-> Run Compatibility Checker
."The only real mistake is the one from which we learn nothing."
John Powell (1834-1902)
John Powell (1834-1902)
"Patience is the companion of wisdom."
Saint Augustine (354 AD - 430 AD)
Saint Augustine (354 AD - 430 AD)
"Success is the ability to go from one failure
to another with no loss of enthusiasm."
Sir Winston Churchill (1874 - 1965)
to another with no loss of enthusiasm."
Sir Winston Churchill (1874 - 1965)
From: "wrmosca@comcast.net" <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, March 21, 2014 10:33 AM
Subject: [MS_AccessPros] Re: Continuous form conditional format
John
What compatibility checker are you talking about? You might want to try decompiling the database. First, make a backup copy. Then follow the instructions at http://www.fmsinc.com/microsoftaccess/performance/decompile.asp
Bill
---In MS_Access_Professionals@yahoogroups.com, <shelbysalpha@yahoo.com> wrote :
Okay! This is strange. Conditional formatting was working on my copy. I emailed the front end to other users and the conditional formatting would not work. I went home for the day and tried VPN access to the back end and conditional formatting would not work. When I came in this morning after closing Access over night my conditional formatting would not work. I compacted & repaired the data base but that did not fix it. After running the Compatibility Checker the formatting works! - until you close and reopen the data base. You have to run the Compatibility Checker to get the formatting to work...
."The only real mistake is the one from which we learn nothing."
John Powell (1834-1902)
John Powell (1834-1902)
"Patience is the companion of wisdom."
Saint Augustine (354 AD - 430 AD)
Saint Augustine (354 AD - 430 AD)
"Success is the ability to go from one failure
to another with no loss of enthusiasm."
Sir Winston Churchill (1874 - 1965)
to another with no loss of enthusiasm."
Sir Winston Churchill (1874 - 1965)
From: "wrmosca@comcast.net" <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, March 19, 2014 10:36 AM
Subject: [MS_AccessPros] Re: Continuous form conditional format
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, March 19, 2014 10:36 AM
Subject: [MS_AccessPros] Re: Continuous form conditional format
John
Select the text box in design view. Use Conditional formatting and select "Expression" as the type. Put something like this in the expression box:
[myCheckBox]=True
You'll need 2 conditions: one if the checkbox is true and one if it is false.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <shelbysalpha@yahoo.com> wrote :
Is there a way to have check box on a record control the background color of a text box on the same record of a continuous form?
."The only real mistake is the one from which we learn nothing."
John Powell (1834-1902)
John Powell (1834-1902)
"Patience is the companion of wisdom."
Saint Augustine (354 AD - 430 AD)
Saint Augustine (354 AD - 430 AD)
"Success is the ability to go from one failure
to another with no loss of enthusiasm."
Sir Winston Churchill (1874 - 1965)
to another with no loss of enthusiasm."
Sir Winston Churchill (1874 - 1965)
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (15) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar