field property descriptions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

confused - 29 May 2007 19:53 GMT

is there a list somewhere of descriptions/definitions for the properties
listed on a field's property sheet?

i am thinking specifically of the properties for a text box in a form but i
am frequently unsure of exactly what a certain property does. ex: what is the
difference between the "enabled" and "locked" properties? What do "on dirty"
and "on got focus" mean?

i apologize if this is a repost but after searching all of access i didn't
find my answer.

Reply to this Message

Douglas J. Steele - 29 May 2007 20:05 GMT

Try putting your cursor into any of the properties and then hitting F1 to
see what Help returns.

In answer to your specific questions, the Enabled property specifies whether
a control can have the focus in Form view, while the Locked property
specifies whether you can edit data in a control in Form view.

The apparent "On Dirty" and "On Got Focus" properties are really how to get
to events: they're not true properties (other than you set them to indicate
what to do when the event occurs). The Dirty event occurs when the Dirty
property changes. The Dirty property can be used to determine whether the
current record has been modified since it was last saved (When a record is
saved, Microsoft Access sets the Dirty property to False. When a user makes
changes to a record, the property is set to True. You can actually force a
save by setting the Dirty property to False.) The GotFocus event occurs when
a form or control receives the focus. (there's a corresponding LostFocus
event which occurs when a form or control loses the focus)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> is there a list somewhere of descriptions/definitions for the properties
> listed on a field's property sheet?
[quoted text clipped - 9 lines]
> i apologize if this is a repost but after searching all of access i didn't
> find my answer.

Reply to this Message

confused - 29 May 2007 21:54 GMT

thanks for the clarification on my specific questions. that helps a lot.

F1 brings up property specific help for certain properties and just opens
help for others (i still can't find anything in help re: enabled & locked
properties).

i was hoping that somebody somewhere (or microsoft for that matter) had a
consolidated list of descriptions of the items listed in the various property
sheets.

thanks again for your help.

> Try putting your cursor into any of the properties and then hitting F1 to
> see what Help returns.
[quoted text clipped - 27 lines]
> > i apologize if this is a repost but after searching all of access i didn't
> > find my answer.

Reply to this Message

Douglas J. Steele - 30 May 2007 01:10 GMT

All of the properties are in the Help file: you just have to look for them.
That's the only consolidated list of descriptions that I'm aware of.

Specific for enabled & locked:
http://msdn2.microsoft.com/en-us/library/aa194969(office.10).aspx (Don't
worry if you're not using Access 2000: it's the same for all versions)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> thanks for the clarification on my specific questions. that helps a lot.
>
[quoted text clipped - 51 lines]
>> > didn't
>> > find my answer.

Reply to this Message