Just learned this myself and thought I'd pass it along.
If you need a carriage return or line break between phrases in an expression, you can use the abreviation "vbcrlf". For example, if you're doing a mailing list and want to stick two address lines (street address and apartment #) into one textbox, you can do the following:
The above code tests the 2nd address field for a null or blank value. If it does have null or blank, it only prints the first address field. If the 2nd address field has a valid value, it will print the first address field with the second address field on a second, seperate line.
Apparently, this carriage return also works in charts, though I have yet to test that feature.
Hope that helps someone!
Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???
If you need a carriage return or line break between phrases in an expression, you can use the abreviation "vbcrlf". For example, if you're doing a mailing list and want to stick two address lines (street address and apartment #) into one textbox, you can do the following:
Code:
= iif(isnothing(Fields!Addr2.Value), Fields!Addr1.Value, Fields!Addr1.Value & vbcrlf & Fields!Addr2.Value)The above code tests the 2nd address field for a null or blank value. If it does have null or blank, it only prints the first address field. If the 2nd address field has a valid value, it will print the first address field with the second address field on a second, seperate line.
Apparently, this carriage return also works in charts, though I have yet to test that feature.
Hope that helps someone!
Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???