squares instead of vbCR

[fishqqq]

Me.Notes = "THIS IS A STATUS UPDATE" & vbCr & vbCr & "Shipment Status"


Can anyone tell me how to get this code to do the "carriage return"
instead of putting little squares where the returns should be? the
field Notes is a Memo field (if that means anything).

Thanks
Steve

 

[FireGeek822]

Replace vbCr with vbcrlf - "Carriage Return/Line Feed" is what you are
looking for.

Tammy

 

[fishqqq]

Tks Tammy,
works perfectly.
i noticed now that what this does is erace what was previously place in
the field NOTES with the current information. How do i get this to
"carriage Rtn" a couple of lines and input the current information
WITHOUT eracing what was previously in that field?

tks
Steve

 

[FireGeek822]

Steve,

You will need to call out the item in that field and then concatenate
it with your new information.

SQL = "SELECT * FROM tblName WHERE ....
SET RS = CurrentDB.OpenRecordset("SQL")
RS.Edit
RS![NotesField] = RS![NotesField] & vbCrlf & vbCrlf & NewNotesItem
RS.Update
RS.Close

Hope this helps.

T-

 

[fishqqq]

Sorry Tammy
you just went over my head ... not sure how to call out the field in
question.

can you walk me through it?
-S

 

[Duane Hookom]

Me.Notes = Me.Notes & vbCrLf & vbCrLf & "THIS IS A STATUS UPDATE" & vbCrLf &
vbCrLf & "Shipment Status"

 

[FireGeek822]

Duane has ab better rendition of this. Thanks Duane.

 

[FireGeek822]

Duane has ab better rendition of this. Thanks Duane.