Carriage Return

  • Thread starter Thread starter PR
  • Start date Start date
P

PR

I have some data in multi fields and I am try to enter the data into one
field, I have done the query to enable this, but I want to put a carriage
return between the fields as I append the data to the new field.

Can anyone help.

PR
 
Chr$(13) & Chr$(10). For example ...

UPDATE tblTest SET tblTest.TestMemo = [TestText] & Chr$(13) & Chr$(10) &
[PathName]
WHERE (((tblTest.TestText) Is Not Null) AND ((tblTest.PathName) Is Not
Null));
 
PR,
[Field1] & vbCrLf & [Field2] & vbCrLf... etc...
should concatenate the data the way you want.
 
vbCrLf works great in code/module but will fail in query expressions and
control sources.

--
Duane Hookom
MS Access MVP


Al Camp said:
PR,
[Field1] & vbCrLf & [Field2] & vbCrLf... etc...
should concatenate the data the way you want.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

PR said:
I have some data in multi fields and I am try to enter the data into one
field, I have done the query to enable this, but I want to put a carriage
return between the fields as I append the data to the new field.

Can anyone help.

PR
 
Thanks for that correction...
Al Camp

Duane Hookom said:
vbCrLf works great in code/module but will fail in query expressions and
control sources.

--
Duane Hookom
MS Access MVP


Al Camp said:
PR,
[Field1] & vbCrLf & [Field2] & vbCrLf... etc...
should concatenate the data the way you want.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

PR said:
I have some data in multi fields and I am try to enter the data into one
field, I have done the query to enable this, but I want to put a carriage
return between the fields as I append the data to the new field.

Can anyone help.

PR
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top