[AccessD] Fields with Null

Aah you're using this in SQL aren't you, not code. Vbcrlf is VBA so
code-only. Ok, so going back to the chr(13) & chr(10) try:

("COMMENTS: "+[Comments]+(Chr(13) & Chr(10))) & ("REMARKS:
"+[Remarks]+(Chr(13) & Chr(10))) & ("INV COMMENTS: "+[InvComments])

--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "accessd at databaseadvisors.com" <accessd at databaseadvisors.com>
Subject: [AccessD] Fields with Null
Date: 02/02/07 14:47


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

________________________________________________
Message sent using UebiMiau 2.7.2