[AccessD] sql string problem

Joe:

Create your strings in a string variable (Dim strColumn as String) then show
it in a msgbox with beginning and ending asterisks so you can see any blanks
front and aft:

msgbox "*" & strColumn & "*"

That will probably show you where the error is.

HTH

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com


----- Original Message ----- 
From: "Joe Hecht" <jmhla at earthlink.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Thursday, June 24, 2004 6:06 PM
Subject: [AccessD] sql string problem


> I am trying to create a column for a combo box.
>
> tblMasterAddresses
>
> Fields
>
> LastName
>
> FirstName1
>
> FirstName2
>
> Pseudocode: If firstname2 ="",lastname,firstname1,lastname,firstname1 and
> firstname2
>
> DispName:  IIf ( [tblMasterAddresses]![FirstName2] = "",
> [tblMasterAddresses]![LastName] &" [tblMasterAddresses]![FirstName1] ,
> [tblMasterAddresses]![LastName] &",  "&[tblMasterAddresses]![FirstName1]&
> "and " & [tblMasterAddresses]! [FirstName2]  )
>
>
>
> I keep getting string error the last 30 minutes I have been working on it.
>
>
>
> Thanks
>
>
>
> JOE HECHT
>
> LOS ANGELES CA
>
> jmhla at earthlink.net
>
>
>
>


----------------------------------------------------------------------------
----


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