Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Blending fields
- Thread starter RAClarke
- Start date
Yes
The Control source of field 3 will be like this:
=Field1 & Field2
Be careful of how the controls are named. Access will name the control with the same name as the field from the table. This causes problems when referencing the data in another place. A #Error will be displayed because Access doesn't know if you are referring to the control or to the field in the table.
To avoid this, name the controls on the form like this: txtField1, txtField2, etc.
The Control source of field 3 will be like this:
=Field1 & Field2
Be careful of how the controls are named. Access will name the control with the same name as the field from the table. This causes problems when referencing the data in another place. A #Error will be displayed because Access doesn't know if you are referring to the control or to the field in the table.
To avoid this, name the controls on the form like this: txtField1, txtField2, etc.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
