Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linefeed in Report textbox 1

Status
Not open for further replies.
Muttley

Muttley

MIS
Nov 22, 2000
50
US
Hi

How do I insert a linefeed/carriage return character in a textbox on a report? I've tried using the following syntax, which doesn't seem to work:

= [address1] & Chr(13) & [address2]

also:

= [address1] & vbCrLf & [address2]

Any tips?

TIA

Muttley

 
Sort by date Sort by votes
Try this:

=[Address1] & Chr(13) & Chr(10) & [Address2]

HTH Joe Miller
joe.miller@flotech.net
 
Upvote 0 Downvote
Joe

Thanks a million, that worked great!

Muttley
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
235
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
264
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
238
dhookom
dhookom
monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
230
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
248
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top