[AccessD] (no subject)

Well THAT is a nifty trick. Works like a charm. Thank you Gustav.

Regards,
Karen Rosenstiel
Seattle WA USA

> Hi Karen
>
> Try with
>
> Trim([LastName] & (", " + [FirstName]))
>
> No comma if FirstName is Null.
> Or do it vice versa if LastName can be Null.
>
> /gustav
>
>>>> karenr7 at oz.net 25-06-2006 20:42:27 >>>
> When I use this on an unbound field in a form I get the good old "Extra )
> in query expression" bug. I keep forgetting what the fix is.
>
> Trim([LastName] &", "& [FirstName])
>
> This is so dam annoying!
>
> Regards,
> Karen Rosenstiel
> Seattle WA USA
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>