Form Problem

[Sonnyboy]

I changed the format of a field in a table and I want that change to be reflected in the form that I use for data entry. Is there a way to update the form so that it recognizes that change.

What I did was design a form, and then decided to change a field in the table. I wanted to set a custom format for that field. But the form does not reflect the change that I made to the table.

Thanks for your help

 

[neileg]

Open up the control properties sheet for the control that is bound to that field and set the format in there.

 

[boblarson]

Just an FYI to you Sonnyboy - Formats don't necessarily follow objects into their various incarnations (queries, forms, reports). So, the safest bet is to format at the point of display. So, if you are using a form, do it in the form; if in a report, do it in the report, etc.

 

[Sonnyboy]

I thank everone for their reply to my request. I have re-done my table and created a new form. I am currently working on another problem that makes the last one look easy.

Thanks a lot
Sonnyboy