squares instead of vbCR

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

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
 
Replace vbCr with vbcrlf - "Carriage Return/Line Feed" is what you are
looking for.

Tammy
 
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
 
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-
 
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
 
Me.Notes = Me.Notes & vbCrLf & vbCrLf & "THIS IS A STATUS UPDATE" & vbCrLf &
vbCrLf & "Shipment Status"
 
Back
Top