I have a text box in a form that I want to feed into a memo box on the same 
form I am having trouble getting this to work in VBA. I imagine that the user 
would type their sentance or not in the text box and then click a button and 
it would appear in the memo with a time tamp and the sentance. if they did a 
new sentance and clicked again it would add to the memo on a new line and 
keep any old info. ANy ideas?

Me.MyMemoField = Me.MyMemoField & _
  IIf(Len(Nz(Me.MyMemoField, vbNullString)) > 0, vbCrLf, vbNullString) & _
  Me.MyTextField

-- 
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"jwebster1979" <jwebster1979@discussions.microsoft.com> wrote in message 
news:2680366B-CEA2-4B7B-8362-559AA35359F0@microsoft.com...
>I have a text box in a form that I want to feed into a memo box on the same
> form I am having trouble getting this to work in VBA. I imagine that the 
> user
> would type their sentance or not in the text box and then click a button 
> and
> it would appear in the memo with a time tamp and the sentance. if they did 
> a
> new sentance and clicked again it would add to the memo on a new line and
> keep any old info. ANy ideas? 

On Fri, 7 May 2010 09:52:14 -0700, jwebster1979
<jwebster1979@discussions.microsoft.com> wrote:

>I have a text box in a form that I want to feed into a memo box on the same 
>form I am having trouble getting this to work in VBA. I imagine that the user 
>would type their sentance or not in the text box and then click a button and 
>it would appear in the memo with a time tamp and the sentance. if they did a 
>new sentance and clicked again it would add to the memo on a new line and 
>keep any old info. ANy ideas?

If you have some table with many notes, and you want each note timestamped
(and perhaps you also want the notewriter identified), I'd really strongly
suggest a different approach. It's hard to search or sort data in big memo
fields, and just dumping a lot of disparate information into a memo makes it
difficult to work with!

Consider instead having a one to many relationship to a Notes table, with a
foreign key to this table; a NoteTime, default value =Now() to automatically
timestamp it; a Text or Memo field for the note text; and perhaps a NoteBy
field for the author's name or logon ID. You could then have a Subform based
on this notes table.
-- 

             John W. Vinson [MVP]

Thankyou that works great one more question. I also want a check box that 
will turn the text red for a specific note and hold that color to draw 
attention to to it. Or if it is not checked the text will be black and hold 
that color. Let me know if you know how to do that. Either way I appreciate 
your help!!


"Douglas J. Steele" wrote:

> Me.MyMemoField = Me.MyMemoField & _
>   IIf(Len(Nz(Me.MyMemoField, vbNullString)) > 0, vbCrLf, vbNullString) & _
>   Me.MyTextField
> 
> -- 
> Doug Steele, Microsoft Access MVP
> http://www.AccessMVP.com/DJSteele
> (no e-mails, please!)
> 
> "jwebster1979" <jwebster1979@discussions.microsoft.com> wrote in message 
> news:2680366B-CEA2-4B7B-8362-559AA35359F0@microsoft.com...
> >I have a text box in a form that I want to feed into a memo box on the same
> > form I am having trouble getting this to work in VBA. I imagine that the 
> > user
> > would type their sentance or not in the text box and then click a button 
> > and
> > it would appear in the memo with a time tamp and the sentance. if they did 
> > a
> > new sentance and clicked again it would add to the memo on a new line and
> > keep any old info. ANy ideas? 
> 
> 
> .
> 

Turn all of the text red or black? Look into Conditional Formatting.

-- 
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele
(no e-mails, please!)



"jwebster1979" <jwebster1979@discussions.microsoft.com> wrote in message 
news:9A419696-1C64-4FE0-A4EE-033F7D73A56B@microsoft.com...
> Thankyou that works great one more question. I also want a check box that
> will turn the text red for a specific note and hold that color to draw
> attention to to it. Or if it is not checked the text will be black and 
> hold
> that color. Let me know if you know how to do that. Either way I 
> appreciate
> your help!!
>
>
> "Douglas J. Steele" wrote:
>
>> Me.MyMemoField = Me.MyMemoField & _
>>   IIf(Len(Nz(Me.MyMemoField, vbNullString)) > 0, vbCrLf, vbNullString) & 
>> _
>>   Me.MyTextField
>>
>> -- 
>> Doug Steele, Microsoft Access MVP
>> http://www.AccessMVP.com/DJSteele
>> (no e-mails, please!)
>>
>> "jwebster1979" <jwebster1979@discussions.microsoft.com> wrote in message
>> news:2680366B-CEA2-4B7B-8362-559AA35359F0@microsoft.com...
>> >I have a text box in a form that I want to feed into a memo box on the 
>> >same
>> > form I am having trouble getting this to work in VBA. I imagine that 
>> > the
>> > user
>> > would type their sentance or not in the text box and then click a 
>> > button
>> > and
>> > it would appear in the memo with a time tamp and the sentance. if they 
>> > did
>> > a
>> > new sentance and clicked again it would add to the memo on a new line 
>> > and
>> > keep any old info. ANy ideas?
>>
>>
>> .
>> 

On Fri, 7 May 2010 15:36:01 -0700, jwebster1979
<jwebster1979@discussions.microsoft.com> wrote:

>Thankyou that works great one more question. I also want a check box that 
>will turn the text red for a specific note and hold that color to draw 
>attention to to it. Or if it is not checked the text will be black and hold 
>that color. Let me know if you know how to do that. Either way I appreciate 
>your help!!

If you have all the data in one single big memo field, this will be difficult.
At the best you'll need to make it a Rich Text textbox (which will make it
even *more* difficult to search), with either manual selection of the text you
want to see in red or some REALLY complex VBA code. It would be much easier if
each note were in a separate record - then you could use conditional
formatting.

-- 

             John W. Vinson [MVP]