Help Setting Up Calculated Text Field in a Form based on two text in two other Fields

[Bill Newport Beach]

I’m making a Form that will be used to enter data into a Table.



There are three text fields in the Table.

I would like to make one of the fields able to calculate its text entry based on the contents of the two other text fields.

What is the best way to accomplish this?

Many thanks in advance for any help!!!

Bill

[JoeM]

Short answer - you don't. It is generally considered bad practice to do so.
The general rule of thumb is NEVER store anything that can be calculated. You can use a query to create your calculated field. Queries can be used as the source of Forms, Report, and Exports, just like Tables can.

In newer versions of Access (I believe 2010 and newer), you can actually store calculated fields in Tables instead of Queries, though it is not generally recommended. If you ever needed to convert your tables down to the road to something like SQL, it wouldn't work, because most real database programs do not allow the storage of calculated fields in tables.