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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Two Tables Using One Form Contents 0
Updating a Form when Table design is changed 4
Prevent Duplicate Form Entries 0
Saving Form Changes When Database Tables Change 3
How to Update Changes of Form to Table 2
update data in one table using form 3
Separate Form 0
how do I change a source table on a form without recreating form 2

Back
Top