convert memo to text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with some tables that I cannot alter and I need a certain field
in text format instead of memo. What function would i use in the query
expression to get text output?
 
Not sure what you want. A memo field contains string data; a text field
contains string data. The only difference is the length of the string that
can be stored in the field.

Perhaps if you tell us what you're trying to achieve, someone can help you
do that.
 
Let's say that a field in a table named OBJECT_CN is a text field that for
some reason only contained numbers. I know that in a query I can use the
expression <new_column_name>:Val([OBJECT_CN]) to convert it to a number field
in the query output.

I am trying to accomplish something similar. What function would I use in
place of "Val" to convert a memo field to a text field?

There is at least one more difference between text and memo: memo cannot be
used to link two tables in a query and text can. That is why I'm trying to
convert a memo field to a text field.
 
You could use
Left([MemoFieldName], 255)

--

Ken Snell
<MS ACCESS MVP>

Phekyl said:
Let's say that a field in a table named OBJECT_CN is a text field that for
some reason only contained numbers. I know that in a query I can use the
expression <new_column_name>:Val([OBJECT_CN]) to convert it to a number
field
in the query output.

I am trying to accomplish something similar. What function would I use in
place of "Val" to convert a memo field to a text field?

There is at least one more difference between text and memo: memo cannot
be
used to link two tables in a query and text can. That is why I'm trying
to
convert a memo field to a text field.

Ken Snell said:
Not sure what you want. A memo field contains string data; a text field
contains string data. The only difference is the length of the string
that
can be stored in the field.

Perhaps if you tell us what you're trying to achieve, someone can help
you
do that.
Click to expand...
Click to expand...
 
Back
Top