Changing Field Size

[Tim Fierro]

Hello,

I have a table (Items) with a field in it called (ItemNumber). Currently
(ItemNumber) is 32 characters long and I would like to change this to expand
it's limit to 40 characters.

Question: If I make the change in the table design so that it would now be
40 characters, are there any GOTCHAS! I need to be concerned with?

I totally understand that some forms and/or reports that use this field
might need to be adjusted to show the extra 8 characters now, but that is
fine. My main concern is that if I change this limit from 32 characters to
a new limit of 40 characters, that I don't mess up something that I am
unaware of in the structure.

Tim

 

[Rick Brandt]

Hello,

I have a table (Items) with a field in it called (ItemNumber). Currently
(ItemNumber) is 32 characters long and I would like to
change this to expand it's limit to 40 characters.

Question: If I make the change in the table design so that it would
now be 40 characters, are there any GOTCHAS! I need to be concerned
with?
I totally understand that some forms and/or reports that use this
field might need to be adjusted to show the extra 8 characters now,
but that is fine. My main concern is that if I change this limit
from 32 characters to a new limit of 40 characters, that I don't mess
up something that I am unaware of in the structure.

Tim

Generally going larger is not a problem. Going smaller such that some existing
data would be lost would be a problem.

 

[Tim Fierro]

"Rick Brandt" wrote in message

Generally going larger is not a problem. Going smaller such that some
existing data would be lost would be a problem.

Thank you Rick for the answer. My mind is a little more at ease to make the
change now.

Tim