Comments Sub Form

[pat]

Hi:

I have a main form with a subform which is a comments
field. The problem is that I have this set up as a text
field of 50.

I need this field to have more then one line in order by
entry date.

Ex:

Record 1
Comments: The flight number for United is 1515
Use United Airlines
Please advise what line to use.

As you can see there are 3 records but all visible.

I have an index on record.

Thanks for the assistance

 

[Larry Linson]

Consider a related table with multiple comment lines per whatever is the
subject of the main form. That will be simpler, although you can add text to
a field... you'll just have to redefine it to Memo instead of Text, and set
the cursor with SelTxt and SelStart, so you add to the end. Chr$(10) &
Chr$(13) are the characters that cause a "new line" for the text that
follows... you can add those in with code. Unless you have changed the
options, "Ctrl" + "Enter" will make a new line within the same control,
though.

Larry Linson
Microsoft Access MVP

 

[Pat]

Hello:

This table is a SQL table, I am only linking to it and am
not able to change from varchar2 to memo. There is no
memo in sql2?

Also, Im not quite sure where to enter the cursor data?

Thanks

Pat