Looking for a little education on VBA code

[Rick]

hi dandgard

thanks for this info - I use the "" alot in Excel (where I do not use any VBA or macros, makes it easier to email files without code attached). I haven't come across a usage for this info yet in Access, but since I'm still 'new' I'm sure that some opportunity will arise in the future

again, thanks for responding 'cause it all helps in the long run..

Rick..

----- dandgard wrote: ----


just another note here. The return from the Nz function need not be
numeric value, it can also be a string - specifically sometimes yo
don't want a value but a "" (empty string) instead of some value