data does not display table when expresions are used in Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Douglas - 15 Jul 2005 13:26 GMT

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

Reply to this Message

Rick Brandt - 15 Jul 2005 13:52 GMT

> 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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Douglas - 15 Jul 2005 14:18 GMT

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

> > 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.

Reply to this Message

John Vinson - 15 Jul 2005 17:09 GMT

>Thanks for the reply. I dont 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]

Reply to this Message

Rick B - 15 Jul 2005 13:58 GMT

"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.

Signature

Rick B

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

Reply to this Message