Truncated entries

[Ellen]

Hello,
I have updated a text field with one of a memo field.
There are entries that have been truncated. Is there a
way to search for all fields with 255 characters?

Thank you in advance,
Ellen

 

[Rick B]

Sure.

Build a query and add a new column with something like:

Len([SomeFieldName])


This will return the length. You could add criteria to say =255


Rick B


Hello,
I have updated a text field with one of a memo field.
There are entries that have been truncated. Is there a
way to search for all fields with 255 characters?

Thank you in advance,
Ellen

 

[Ellen]

Thanks, Rick. Could you give me more details on how this
would be done? Would I do a query with my field with a
criteria of Len([255])?

Thanks in advance.

Ellen

 

[Rick B]

No,

Add a new column to your query with an entry in the "Field:" of:...

Len([YourFieldNameHere])


Then in the "Criteria:" under that item, put...

=255


Rick B




Thanks, Rick. Could you give me more details on how this
would be done? Would I do a query with my field with a
criteria of Len([255])?

Thanks in advance.

Ellen

 

[Duane Hookom]

You might want to set the criteria to >=254 since the 255th character might
have been a space.

--
Duane Hookom
MS Access MVP

No,

Add a new column to your query with an entry in the "Field:" of:...

Len([YourFieldNameHere])


Then in the "Criteria:" under that item, put...

=255


Rick B




Thanks, Rick. Could you give me more details on how this
would be done? Would I do a query with my field with a
criteria of Len([255])?

Thanks in advance.

Ellen

-----Original Message-----
Sure.

Build a query and add a new column with something like:

Len([SomeFieldName])


This will return the length. You could add criteria to say =255


Rick B


Hello,
I have updated a text field with one of a memo field.
There are entries that have been truncated. Is there a
way to search for all fields with 255 characters?

Thank you in advance,
Ellen


.

 

[John Vinson]

Hello,
I have updated a text field with one of a memo field.
There are entries that have been truncated. Is there a
way to search for all fields with 255 characters?

Thank you in advance,
Ellen

Text fields are limited to 255 characters. Could you explain what you
mean by "updated a text field with one of a memo field"? What does
updating a text field have to do with searching a field?

You can use a Query with a calculated field:

FieldLen: Len([memofield])

and use a criterion of >255 on this calculated field to find all
records where the memo is longer than will fit in a Text.

 

[Ellen]

Thanks, Rick and Duane.

Should it look like this?
SELECT CEDI.MAINTERM, Len([MAINTERM]) AS Expr1
FROM CEDI
WHERE (((Len([MAINTERM]))>=254));

MAINTERM is my field name. CEDI is the table name.

Ellen

-----Original Message-----
You might want to set the criteria to >=254 since the 255th character might
have been a space.

--
Duane Hookom
MS Access MVP

No,

Add a new column to your query with an entry in the "Field:" of:...

Len([YourFieldNameHere])


Then in the "Criteria:" under that item, put...

=255


Rick B




Thanks, Rick. Could you give me more details on how this
would be done? Would I do a query with my field with a
criteria of Len([255])?

Thanks in advance.

Ellen

-----Original Message-----
Sure.

Build a query and add a new column with something like:

Len([SomeFieldName])


This will return the length. You could add criteria to say =255


Rick B


Hello,
I have updated a text field with one of a memo field.
There are entries that have been truncated. Is there a
way to search for all fields with 255 characters?

Thank you in advance,
Ellen


.

.

 

[Guest]

John,
I probably mixed up my terms. I updated my table that has
the text field, with a memo field from another table. The
memo fields with more than 255 characters got truncated
when placed into the text field.

I'd like to correct that with a query that will rerun the
update only on those fields with 255 characters or those
that got truncated.

Hopefully, you get the idea.

-----Original Message-----

Hello,
I have updated a text field with one of a memo field.
There are entries that have been truncated. Is there a
way to search for all fields with 255 characters?

Thank you in advance,
Ellen

Text fields are limited to 255 characters. Could you explain what you
mean by "updated a text field with one of a memo field"? What does
updating a text field have to do with searching a field?

You can use a Query with a calculated field:

FieldLen: Len([memofield])

and use a criterion of >255 on this calculated field to find all
records where the memo is longer than will fit in a Text.


.

 

[Duane Hookom]

Did you try it?

--
Duane Hookom
MS Access MVP

Thanks, Rick and Duane.

Should it look like this?
SELECT CEDI.MAINTERM, Len([MAINTERM]) AS Expr1
FROM CEDI
WHERE (((Len([MAINTERM]))>=254));

MAINTERM is my field name. CEDI is the table name.

Ellen

-----Original Message-----
You might want to set the criteria to >=254 since the 255th character might
have been a space.

--
Duane Hookom
MS Access MVP

No,

Add a new column to your query with an entry in the "Field:" of:...

Len([YourFieldNameHere])


Then in the "Criteria:" under that item, put...

=255


Rick B




Thanks, Rick. Could you give me more details on how this
would be done? Would I do a query with my field with a
criteria of Len([255])?

Thanks in advance.

Ellen
-----Original Message-----
Sure.

Build a query and add a new column with something like:

Len([SomeFieldName])


This will return the length. You could add criteria to
say =255


Rick B


message
Hello,
I have updated a text field with one of a memo field.
There are entries that have been truncated. Is there a
way to search for all fields with 255 characters?

Thank you in advance,
Ellen


.

.