format and input mask

[fvd]

Hi there,

I've made a database with 5 tables, bud did not make any format's or input masks there.
But now that all of my forms and reports are finished, i tried to fill them in in the tables.
But the forms and reports did not take them over (if i look in the properties of all the textfields, they are empty).
Only the validation rules were taken over by the forms, but not the inputmasks or the format's...
So now i have to specify them in all of the forms and reports.
Does anybody know an easier way how i can make the forms take over the same properties as in the tables???
I think i better made the inputmasks when i made the tables, so the forms would have taken them over, isn't it?

Thanks already!

 

[neileg]

I think you know what has happened. When you create a form, it inherits formats from the underlying tables. However, this is a one off operation, not dynamic. You can change the formats in the table, or in the form, and these don't transfer to the other object. On the whole, i think it is better to format in the form, and leave the table unformatted, except for dates.

You need to go into each form and set your formats, don't bother with the tables.

 

[fvd]

Hi Neil,

Thanks for your reply, i'll certainly think about it the next time i make a database!

I think you know what has happened. When you create a form, it inherits formats from the underlying tables. However, this is a one off operation, not dynamic. You can change the formats in the table, or in the form, and these don't transfer to the other object. On the whole, i think it is better to format in the form, and leave the table unformatted, except for dates.

You need to go into each form and set your formats, don't bother with the tables.