Truncated entries


E

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
 
Ad

Advertisements

R

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
 
E

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
 
R

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
 
D

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


Rick B said:
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


.
 
J

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

Advertisements

E

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


.


.
 
G

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.


.
 
Ad

Advertisements

D

Duane Hookom

Did you try it?

--
Duane Hookom
MS Access MVP


Ellen said:
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


.


.
 

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