data does not display table when expresions are used in Form

[Douglas]

How do I get data that does not display table when expresions are used in
Forms but the data is displayed in the form.

 

[Rick Brandt]

How do I get data that does not display table when expresions are
used in Forms but the data is displayed in the form.

By using the same expression that is on the form.

 

[Rick B]

"How do I get data that does not display table "

What does that mean?

If you are using an expression in a form, what is the expression? Did this
expression create data for a field in the table and save that data when you
first created the record?

Is this expression using other data that is stored in other fields in the
database? If so, you don't want to store it more than once in the table.
For example, if you store birtdate in the table, but on your form you
display birthdate, date at which the person will turn 21, and day of the
week the person was born, then you do not need to store those items in the
table. You simply store the birthdate, then use expressions in your forms,
reports, and queries to present the other date. Storing all three would be
redundent and could lead to the various items being out of synch if one
field is changed but the others are not.

 

[Douglas]

Thanks for the reply. I don’t know how to get the expressions in the table.
Can you please help.

 

[John Vinson]

Thanks for the reply. I don’t know how to get the expressions in the table.

You can't, you shouldn't, and you don't need to.

Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.

Just redo the calculation whenever you need it, either as a
calculated field in a Query or just as you're now doing it -
in the control source of a Form or a Report textbox.


John W. Vinson[MVP]