How do I make a Memo Field?

[gwmurray]

Can anyone here tell me exactly how to make a memo field? I need step by
step instructions... i'm new at this and all I can do is create a text
box that has limited characters. The help file in Access isn't very
specific and I can't find where they want you to change "Data Type" in
the properties menu of a field. Alot of thanks to whomever knows!

 

[John Vinson]

Can anyone here tell me exactly how to make a memo field? I need step by
step instructions... i'm new at this and all I can do is create a text
box that has limited characters. The help file in Access isn't very
specific and I can't find where they want you to change "Data Type" in
the properties menu of a field. Alot of thanks to whomever knows!

Open your database in Access.
Select the Tables tab in the database window.
Select the table which needs a memo field.
Click the "Design" button (looks like a triangle and straightedge).
Find the field that you want to be a Memo field.
In the Datatype column select "Memo" from the dropdown box.
Save the Table.

One possible source of your confusion - you may have started (as many
do) with the Forms. The Forms are just tools, windows to manage the
data in your Tables. Start with the Tables first, get *them* right,
and then work on your forms!

 

[gwmurray]

Thanks J you're the best!!!