Using Ascii character to format text in field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Forgot how to place and format 'aggregated' text in a field using Ascii char.
In past used something like:
Setvalue
[field]
[fn] & " " & [ln] & char(13) & char(10) & [PhBus1]

Results in
John Doe
7658887654
 
David Carpenter said:
Forgot how to place and format 'aggregated' text in a field using
Ascii char. In past used something like:
Setvalue
[field]
[fn] & " " & [ln] & char(13) & char(10) & [PhBus1]

Results in
John Doe
7658887654

You want to use

Chr(13) & Chr(10)

instead of
 

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