[AccessD] Fields with Null

That should be IIf not If. I forget switching back and forth between
Access and Excel.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis,
Virginia
Sent: Friday, February 02, 2007 8:46 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Fields with Null

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

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com