View Full Version : Automatically add new line


cooltom
11-23-2001, 12:27 PM
Hi,
I have a memo field in a form. i want it to automatically add new line to the underlined table field and then the text in it. i am using access 2000.

From,
OP

jwindon
11-23-2001, 12:31 PM
A bit vague....more information please?

cooltom
11-23-2001, 12:48 PM
i want to add a "empty line" to the start of the memo field so that when it is saved, it makes the first line of the table field empty and the text of the memo is displayed.

jwindon
11-23-2001, 02:46 PM
Just a guess here, but apparently there is some information that is displayed in the first line of the memo that you do NOT want to show to all users, yet you DO want to save.

My advice is to store the information shown in the first line in a separate field and the memo info in another.

Recently, I gave advice on adding user info and time to a memo field. If that was you, I advise you to split this information into fields. One field that is a foreign key to your main table, two that is the username, 3 the time/date stamp, and 4 the actual memo field. Have this information presented in a subform on your main form.

You can hide the field of the user info or NOT include it when creating the subform.

Blair Greene
11-23-2001, 02:56 PM
if you need a new line in your combo box...
go to design view, select the box, then
select properties and then go to key behavior, that will give you the option
to add new line inside the box for data input...