|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 23rd, 2005, 02:41 AM
posted to microsoft.public.access.reports
|
|||
|
|||
What is line feed character in access report?
Hi,
I have a label that print the following: =IIf(IsNull([SerialNumber]),[NewCode],[NewCode] & Chr(13) & "S/N: " & [SerialNumber]) If the Serail Number is not null, I want the serail number display below the NewCode. So far no success. Anyone suggest something? SF 
|
|
#2
November 23rd, 2005, 03:00 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
What is line feed character in access report?
Carriage return plus line feed:
Chr(13) & Chr(10) -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "SF" wrote in message ... Hi, I have a label that print the following: =IIf(IsNull([SerialNumber]),[NewCode],[NewCode] & Chr(13) & "S/N: " & [SerialNumber]) If the Serail Number is not null, I want the serail number display below the NewCode. So far no success. Anyone suggest something?
|
|
#3
November 23rd, 2005, 04:26 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
What is line feed character in access report?
Big appreciation and thank you for your prompt response.
SF "Allen Browne" wrote in message ... Carriage return plus line feed: Chr(13) & Chr(10) -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "SF" wrote in message ... Hi, I have a label that print the following: =IIf(IsNull([SerialNumber]),[NewCode],[NewCode] & Chr(13) & "S/N: " & [SerialNumber]) If the Serail Number is not null, I want the serail number display below the NewCode. So far no success. Anyone suggest something?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how can I suppress a line feed on a report if the line is null? | MerlinEmrys | Setting Up & Running Reports | 3 | June 23rd, 2007 04:34 AM |
| Line Feed in Report from Unbound Txtbox | NNlogistics | Setting Up & Running Reports | 6 | October 10th, 2005 06:37 PM |
| Can I link 1 form to several tables? | Mico | Using Forms | 7 | July 6th, 2005 07:36 PM |
| double window envelope | tpdebronsky | Page Layout | 4 | May 17th, 2005 07:34 AM |
| Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Linear Mode
