How do I update a form when made changes to formats in tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a database where i have created tables with relationships and
have just finished my form design. I then realised that I needed to change
some of the formats in fields an several tables. How do I update the form to
show these changes from the tables. I don't want to recreate the form again.
 
Alexstar1982 said:
I have designed a database where i have created tables with relationships and
have just finished my form design. I then realised that I needed to change
some of the formats in fields an several tables. How do I update the form to
show these changes from the tables. I don't want to recreate the form again.
Click to expand...

What kinds of formats are you talking about? Do you mean you changed
from General Number to Currency?

When you initially create your form, it inherits the format of the
number (or boolean value or whatever) from the table it is based on.

If you change it in the table afterwards, you will have to fix your
form. Select the control on the form and bring up the properties of the
control and change it's format there.

You aren't recreating the form from scratch, but you do have to do
ongoing form maintenance and redesign as you change your tables.
 
Back
Top