How do calculated fields or text you add in a Form/Report control's "Control Source" property not also become new fields in the Table you built it off of if that s kind of part of the Control Source s definition...?
Setting | Description A field name The control is bound to a field in a table, query, or SQL statement. Data from the field is displayed in the control. Changes to the data inside the control change the corresponding data in the field. (To make the control read-only, set the Locked property to Yes.) If you click a control bound to a field that has a Hyperlink data type, you jump to the destination specified in the hyperlink address.
An expression The control displays data generated by an expression. This data can be changed by the user but isn't saved in the database.
Since you use the "=" for an Expression Access then knows it's not a BOUND Column which saves data back to your Table.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 6.