General question about setting properties

[Victoria]

hello all

I'm thinking about the best place to set certain properties in my database.
Lets say my table has a numerical field. If I set a property like 'Decimal
Places = 3' in the table, can I have confidence that this property will be
passed to any queries and ultimately to forms / reports? What if the
query/form/report tries to imposes a different value for the same property?
Is it best to set any given property for a field at the place where all
'downstream' uses of that field's value will be unchanged? just wonderin'

thank you

 

[Damian S]

Hi Victoria,

The benefit (and also challenge) of using Access is that as you have
discovered, you can set these properties in multiple locations. Personally I
set them all in the forms/queries as required rather than back at the table.
Other posters might disagree with me.

I guess you work out where you like to set them, and be consistent.

Damian.