In Access Memo Cells How format single line entries ?

G

Guest

I need to set properties on a Memo Cell to enter data that is a list, Ex
"date, notes"
"date, notes"
"date, notes"
"etc."
Just like I was just able to do in this "message" box, one item under the
other?
 
R

Rick B

Well, Access does not have "cells" - that is an Excel term.

But, what you are trying to do is not the "best" way to do this in Access.
You are trying to enter a "new" not in an existing field. That violates
Access normalization rules. If you want to track notes and include a time
or date, you need a new table. Access is a *relational database* which
means that data should be stored in separate tables that are *related* to
each other using keys in the various tables.

If these notes apply to a particular client, for example, your tables might
look like this...

TblClientData
ClientNumber
ClientName
ClientAddress1
ClientAddress2
ClientCity
ClientState
ClientZip
etc.


You'd have a seperate table for "notes" or "calls" or "contact" with the
client....

TblClientCalls
ClientNumber
CallDate
CallTime
CallDuration
CallDetails


In this scenario, a client would have one record in the TblClientData. If
they had been called ten times, they'd have ten records in the
TblClientCalls.

In your forms and reports, you'd create a main section with the client
details. You'd have a subform or subreport with the call details.


Now, all that being said, Access has many template databases available on
their website for free. I think there is one called "contact management"
that I have used many times as a starting point for my databases.

I'd recommend you take a look at the samples and use those as your starting
structure.
 
G

Guest

Rick B;

Thanks for the response. Your reply puts me on the right track thanks for
answering....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top