VBA coding question

[OldManEd]

Can someone please explain the difference between:

Forms!<TableName>!<FieldName>.value

and

Forms!<TableName>!<FieldName>.text

EdC

 

[fredg]

Can someone please explain the difference between:

Forms!<TableName>!<FieldName>.value

and

Forms!<TableName>!<FieldName>.text

EdC

You're asking for the difference between a control's Text property and
it's Value property?

The Text property is what you get as you enter a value into a control
on a form, i.e. type 1234 into a control.
The Value property is what you get as soon as you save that entry
(either by saving the record or going to the next control, i.e. as
soon as you press the Enter key or Tab key.
To read a control's Text property, that control must have the focus.
You can read a control's Value from anywhere.