Find truncated fields

[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

 

[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

 

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

 

[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
'====================================================

 

[EllenM]

YES!!! Thanks.

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.