Switching between the properties dialog box and Query Desinger

  • Thread starter Thread starter Conan Kelly
  • Start date Start date
C

Conan Kelly

Hello all,

I am changing the Format property for 83 feilds/columns to Standard format (#,##0.00). I'm leaving the Properties dialog box open
and using the mouse to switch fields and then switch back to the Properties diag. box.

Is there a keyboard shortcut that will allow me to switch between the Properties diag. box and the query designer? Using the mouse
is painfully slow.
 
Dear Conan:

If you are changing the format of multiple columns in a query from some
existing value to a new value (#,##0.00) you could copy the SQL View of the
query to a word processor (for example Woed Pad) and do a global search and
replace.

It would be difficult to find a simpler way.

Tom Ellison
 
What about highlighting all the field that need to be changed at once and
then modify the properties?
 
Karl,

Thanks for the help. I already tried that, but when I highlighted multiple columns, everytime I right-clicked it, I got the Query
Properties. You can't get Field Properties with multiple fields highlighted.

Thanks again,

Conan
 
Back
Top