Field size

  • Thread starter Thread starter tc
  • Start date Start date
T

tc

I am creating a database for my church. My Pastor needs a
section for "comments/history." How do I set this up with
the ability for him to be able to have more than just 255
characters in this field?
 
tc said:
I am creating a database for my church. My Pastor needs a
section for "comments/history." How do I set this up with
the ability for him to be able to have more than just 255
characters in this field?
Click to expand...

Use a Memo field instead of character.
 
Thanks, Rick. I will try that.
-----Original Message-----


Use a Memo field instead of character.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.
Click to expand...
 
Go to DESIGN VIEW of your table
In the top half of the screen, you see the list of fields
you have in your table.
In the 2nd column you see what type each of the fields is
currently set to be.
If your comments/history field is set to be a "TEXT"
field, it will be limited to 255 characters.
Change the type so that this field is a "MEMO" type of
field and you can have almost unlimited space for your
comments.

Also, if you are putting this field in a form - on the
properties of your form - make sure in this field's
properties you set the "ENTER KEY BEHAVIOR" property so
that it says "NEW LINE IN FIELD" otherwise, when you hit
enter, you leave the field - rather than going to the next
line for typing.

Ann
 
Back
Top