[AccessD] Fields with Null

Hollis, Virginia hollisvj at pgdp.usec.com
Fri Feb 2 08:46:04 CST 2007


Gustav: This one gives me 2 little squares where the COMMENTS would be,
and then it puts the REMARKS on the 2nd line.
 
Chester: This gives me an error: Undefinded Function If:
Desc: ("COMMENTS: "+If([Comments] Is Null,"",[Comments]) & (Chr(13) &
Chr(10) & "REMARKS:"+[Remarks]) & (Chr(13) & Chr(10) & "INV COMMENTS:
"+[InvComments]))
 
Andy: First it gives, too many closing parenthesis, so I added some like
before ([Comments]. But then it wants a parameter for vbcrlf.
Desc: "COMMENTS: " + [Comments] + vbcrlf) & "REMARKS:
" + [Remarks] & vbcrlf) & "INV COMMENTS: " + [InvComments]
 
 
 
********************
Hi Virginia
 
Modify it like this:
 
Desc: ("COMMENTS: "+[Comments] + Chr(13) & Chr(10)) & 
("REMARKS: "+[Remarks] + Chr(13) & Chr(10)) & 
("INV COMMENTS: "+ [InvComments])
 
/gustav

 




More information about the AccessD mailing list