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

[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...

 

[Mike Painter]

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...

Select them with shift click or select all and unselect them.

 

[Dirk Goldgar]

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...

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.

 

[Dirk Goldgar]

Select them with shift click or select all and unselect them.

Won't work in *Table* design view.