Find truncated fields


E

EllenM

Hello,
How can I identify cells (are they called records?) with 255 characters. I
need to identify the cells that Access has truncated. I have Access 2003

Thanks,
Ellen
 
Ad

Advertisements

J

Jeff Boyce

Ellen

Access has a text data type that can hold up to 255 characters.

Access has a memo data type that can hold up over 65,000 characters.

When you say you are trying to identify cells (a spreadsheet term, not
applicable in Access) that are truncated, to what will you be comparing?

And then there's the question of "why"? What will knowing this allow you to
do?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
E

EllenM

Hi Jeff,
I'd like to be able to identify the truncated fields so I can fix it. I've
changed the field type from text to memo.
 
J

John Spencer

You can identify fields that have 255 characters by adding a calculated
field to your query.

Field: HowLong: Len([Tablename].[FieldName])
Criteria: > 252

I used 252 not 255 to take care of the possibility that the field got
truncated at a spot where the last two characters were spaces and access
trimmed those spaces.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Ad

Advertisements

E

EllenM

YES!!! Thanks.

John Spencer said:
You can identify fields that have 255 characters by adding a calculated
field to your query.

Field: HowLong: Len([Tablename].[FieldName])
Criteria: > 252

I used 252 not 255 to take care of the possibility that the field got
truncated at a spot where the last two characters were spaces and access
trimmed those spaces.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Hi Jeff,
I'd like to be able to identify the truncated fields so I can fix it. I've
changed the field type from text to memo.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top