CONCATENATE QUESTIONS

[Sammie]

2 questions:
1. When concatenating a string on a report, how can I enter a carriage
return to start a new line? Or enough spaces to accomplish the same
thing? I would like a new line to start after "Ship's spares in
transit" and before [shipaddress] in the first half of my expression.
Here's my statement:
=IIf([ShipSparesInTransit]=-1,"SHIP'S SPARES IN TRANSIT" &
[ShipAddress],[ShipAddress])

2. How do I format the [ship date] field for a long date in this
expression:
=[ship date] & " via " & [carrier]
Thanks.
Sammie

 

[Rick Brandt]

2 questions:
1. When concatenating a string on a report, how can I enter a carriage return
to start a new line? Or enough spaces to accomplish the same thing? I would
like a new line to start after "Ship's spares in transit" and before
[shipaddress] in the first half of my expression. Here's my statement:
=IIf([ShipSparesInTransit]=-1,"SHIP'S SPARES IN TRANSIT" &
[ShipAddress],[ShipAddress])

IIf([ShipSparesInTransit]=-1,"SHIP'S SPARES IN TRANSIT"
& Chr(13) & Chr(10) & [ShipAddress],[ShipAddress])

2. How do I format the [ship date] field for a long date in this expression:
=[ship date] & " via " & [carrier]

=Format([ship date], "long date") & " via " & [carrier]

 

[Sammie]

2 questions:
1. When concatenating a string on a report, how can I enter a carriage return
to start a new line? Or enough spaces to accomplish the same thing? I would
like a new line to start after "Ship's spares in transit" and before
[shipaddress] in the first half of my expression. Here's my statement:
=IIf([ShipSparesInTransit]=-1,"SHIP'S SPARES IN TRANSIT" &
[ShipAddress],[ShipAddress])

IIf([ShipSparesInTransit]=-1,"SHIP'S SPARES IN TRANSIT"
& Chr(13) & Chr(10) & [ShipAddress],[ShipAddress])

2. How do I format the [ship date] field for a long date in this expression:
=[ship date] & " via " & [carrier]

=Format([ship date], "long date") & " via " & [carrier]

WORKS GREAT! THANKS!