Date Stamp on Memo Box

[learning_codes]

Hi,

I use but I notice that the memo box has a limit when I add more
notes each time.

I put "after update".

Me.Comment = Chr(13) & Chr(10) & Chr(13) & Chr(10) & Date & " - - " &
Forms![frm_Room]![Location] & Chr(13) & Chr(10) _ & Now() & " - - " &
Forms![frm_Schedule]![Event] & vbNewLine

I set the size of /"100000" under the field "Comment".

I don't know what did I do wrong.

Your help would be much appreciated.

Thanks

 

[Linq Adams via AccessMonster.com]

What exactly do you mean by:

"I notice that the memo box has a limit when I add more
notes each time."

A memo field has a limit of about 64K characters, which translates roughly to
25 pages or so of single spaced text using a 12 point font. I've used memo
fields for nursing notes on home care patients, with some patients being on
service years, and have never begun to run up against this limit.

And what do you mean by:

"I set the size of /"100000" under the field "Comment""

There is no field size for memo fields, at least not up thru ACC2003. Where
exactly did you put this "100000?"

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com