Changing value in text field

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

We have a access database that we use for delivery tickets.
There is one field that is the "job description"
Our problem is that we can type 5 lines in it. We would
like to put 8 lines.
Does anyone know how to change that.
Thanks
 
Hello,

The maximum number of characters you can have in a text
field is 255. To be able to enter more, make the field
type "Memo" this will allow you to enter up to 65,535
characters.

If this is a field linked to another table you will have
to break the relationship in the relationship window, make
the change and then re-link the field.

Hope this is what you were after.

Regards,

Averil
 
A text field can only accept up to 255 characters. If you have more than
that, you'll need to change the datatype to a memo field. If you have a
limit which is less than that, increase it to allow sufficient characters.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
I don't know how to make the field type "Memo".
Could someone walk me through that?
I tried search the web for help but I still
couldn't find any.
Thanks
 
Back
Top