By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,470 Members | 924 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,470 IT Pros & Developers. It's quick & easy.

Access Look and Feel - Disabled fields

P: 9
I had a quick look but couldnt find much on this.

What i have is a contiunous form with each row having an 'edit' button. By default all feilds have been set to disabled to stop the user acciddently changing data in the bound tables. Im using code along with MS built in conditional formatting so when the user clicks the edit button on a particular row it makes all the controls enabled for that row and they can then edit the data.

My problem is because they are disabled they look really dull so i wanted to know if there was a way to change the default look and feel of disabled controls? I know if u set the control to locked also it will display the proper look however conditional formatting dosent have an option to unlock a control so i would never be able to have the user edit data the way im doing it. Is there away i can have the controls disabled but still display without being greyed out??

Any ideas form the MVPs?? ;)

Cheers heaps

Mar 9 '07 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 12,359
You can lock the fields, in code you can unlock each of the fields.
Mar 9 '07 #2

Expert Mod 10K+
P: 14,534
Hi Mike

The simple answer to your question is no because you are using conditional formatting. One trick I have tried in the past is to set the text to bold as it displays better.

Mar 10 '07 #3

P: 1
I used a different approach to prevent accidental data entry. I formated the background to a lighter, different color, then DATA - Locked = Yes on the first three fields (ID, LName and FName - which are used for lookup mainly and data entry later). I wrote a quick procedure to unlock the field on double-click. Works great. Here's an example on the ID field:

Private Sub ID_DblClick(Cancel As Integer)
Me.ID.Locked = False
End Sub

Now when you need to do data entry to change the info or add a new records you just double-click each of the first three fields to enter data - the powers that be did not want a routine to automatically open the fields for new records.
Jul 31 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.