Creating a Line-by-Line Notes Display

[dustinw101 via AccessMonster.com]

Here's what I'm trying to do and what I'm currently using. Currently, I have
a text box that users use to enter a note about a customers file. They then
press an ADD button with addes the text that they just typed into another
dispaly field with contains all of the previous entries. This data is stored
as a memo type field in the client record.

What I want to do is to create a detail table which I can use to enter a new
record everytime a note is added for the client. The fields would include:
(ClientID/Date/Time/UserID/Note).

My problem is when I try to display the notes that have been entered. I need
to have some type of list box that can dispay all the notes for the client
selected but I need one line to be able to expand to show the data depending
on the size of each line. I'm not having any luck with any subForms,
ListBoxes...etc.

Any suggestions would be helpful

 

[Jeanette Cunningham]

Hi dustinw,
What does the note apply to?
If a customer can have many notes about them, but the notes are not related
to specific things like orders but are just general notes about the
customer, you could have a notes table.
This sounds like the table you described in your post.
Make the relationship one-to-many between the client table and the notes
table.

The user then sees a main form with the customer name and on that form you
put a subform based on the notes table.
This way you can show each note for the same customer,with date, time and
user.
If the notes field is a memo field - in the subform, make the textbox 3 or 4
lines high and put a scrollbar on the textbox.
Each note will be one record in the subform.

You can have a zoom box (a form with a very large textbox) that is opened by
a double click or a right click and shows all the details of a single note -

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia