How to Change the same property of multiple fields in table design view

  • Thread starter Thread starter Spidey3721
  • Start date Start date
S

Spidey3721

Wondering if there is a way to change the same property of multiple fields
in a table (design view) at the same time.

For example - I want to change the number format of about 20 fields to
"standard", with zero decimal places, all in one move - is this possible or
do I have to go through them one by one ?

Thank you for the help...
 
Spidey3721 said:
Wondering if there is a way to change the same property of multiple fields
in a table (design view) at the same time.

For example - I want to change the number format of about 20 fields to
"standard", with zero decimal places, all in one move - is this possible or
do I have to go through them one by one ?

Thank you for the help...
Click to expand...
Select them with shift click or select all and unselect them.
 
Spidey3721 said:
Wondering if there is a way to change the same property of multiple
fields in a table (design view) at the same time.

For example - I want to change the number format of about 20 fields to
"standard", with zero decimal places, all in one move - is this
possible or do I have to go through them one by one ?

Thank you for the help...
Click to expand...

I don't think you can, manually. You could write DAO code to do it, but
writing it would take longer than just doing 20 fields manually.
 
Back
Top