Help! Auto formatting problems

S

splat

I've created a file in Excel. My database is in Access. Whenever I change
data in my worksheet, in Excel, it changes the column width of my A column.
Do I need to deselect something? Why does this automatically change? Please
help!
 
D

Dave Peterson

I'm not sure how Access fits into this, but I've seen xl "help" with numeric
entries--it'll expand the columnwidth to make sure you can see the digits.

If you don't like this, one way to tell excel to stop it is to manually adjust
the columnwidth. Excel won't "help" again until you autofit that column width.

If the columnwidth is too narrow for the numeric value, you'll see ####'s.

I've never seen xl do this on its own for text entries. If it's happening for
text, then maybe you have a "helpful" macro that's resizing when you type the
change.
 
M

Mike A

If the problem is in a data range queried from your Access database, you
can fix the column width adjustment. (It defaults to adjusting it for you.)

Right-click anywhere in the data set that the query returns, and click
Data Range Properties. Uncheck 'Adjust column width'.


Mike Argy
Custom Office solutions and
Windows/UNIX applications
 
Top