Duplicate Items

M

mcavanaugh

In one of our programs, we have a comment field we are trying to add but
after it is added and a comment is put into it, it duplicates it on every
record. How can this be elimated so that each record can have it's own
comment?
 
K

Ken Sheridan

If the comments might be more than 255 characters long add a memo field to
the table in table design view and save the table. On your data input form
add a text box in design view, set its ControlSource to the name of the memo
field and change its EnterKeyBehavior property to 'New Line In Field'.

Do not add a control to a form by dragging the memo field from the field
list; there is a bug which can cause memo fields to appear to be truncated if
added to a form in this way (the same applies to a report). Using the above
approach of adding a text box from the toolbox first and then setting its
ControlSource property overcomes this.

If the comments will be 255 characters or less add a normal text field to
the table.

Ken Sheridan
Stafford, England
 
Top