Ahh ok, that's different. You want the field "dimmed" :)
You do that by setting the Properties->Data->Enabled (and Locked)
properties.
Try setting them manually and you'll see what they do. If you put the
cursor on one of them and F1, Help will give you all the options of
the various combinations you can use.
To set/unset them, then code is
Me!ControlName.Enabled = False
Note that I correctly use ControlName and not FieldName. They are
different. When you create a form, they are automatically the same
(bad idea) but should not be. Let me explain ...
- Your field's Data->ControlSource may be FirstName
- The field's Other->Name should be txtFirstName ... *this* is the
ControlName.
When addressing objects on a form in code, Access is always using the
ControlName, not the ControlSource but most developers have fallen
into the trap of using the ControlSource field name. This is a very
very common problem encountered by everyone at some time or other and
we hope MS will change it in the next release so that when a new field
is created, Access asks for a ControlName and prompts the entry with a
default naming convention prefix like
txt for a textbox
cmd for a button
cbo for a combo box
opt for option group
img for a pic
tab for a tab control
... etc etc ...
Brett
>Brett, thank you for the advice, but the idea behind the semi transparent
>layer, was that by selecting the record, the other records would be slightly
[quoted text clipped - 32 lines]
>> Business & Systems Analyst
>> Management Information Systems Developer
Cheers,
Brett
----------------------------------------------
Be adventurous, be bold, be careful, be a star
----------------------------------------------
Brett Collings
Business & Systems Analyst
Management Information Systems Developer
Timboo - 02 Nov 2004 15:59 GMT
Brett, thank you again, I will give this a try. With regard to the control
name vs field name, what you sy makes sense even to a beginner like myself,
so a little weird that the Microsoft development team overlooked this,
especially as there have been so many version of Access. But there again
just look at the flaws made my major car manufacturers - who have been making
cars for over 100 years....Tim
> Ahh ok, that's different. You want the field "dimmed" :)
>
[quoted text clipped - 79 lines]
> Business & Systems Analyst
> Management Information Systems Developer