Truncated entries

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

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


"Ellen" wrote in 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

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


"Ellen" wrote in
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


.

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




"Ellen" wrote in message
...
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


"Ellen" wrote in
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


.

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" wrote in message
...
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




"Ellen" wrote in message
...
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


"Ellen" wrote in
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


.

On Wed, 18 Aug 2004 11:53:46 -0700, "Ellen"
wrote:

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

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


"Rick B" wrote in
message
...
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




"Ellen" wrote in
message
...
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


"Ellen" wrote in
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


.





.

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-----
On Wed, 18 Aug 2004 11:53:46 -0700, "Ellen"
wrote:

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
.

Did you try it?

--
Duane Hookom
MS Access MVP


"Ellen" wrote in message
...
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


"Rick B" wrote in
message
...
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




"Ellen" wrote in
message
...
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


"Ellen" wrote in
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


.





.