MarkH
lists at theopg.com
Thu Jul 15 13:48:55 CDT 2004
Cheers Gustav... I was worried I was missing something there :@) Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: 15 July 2004 08:28 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Erasing / clearing a user defined type Hi Mark > This is a question I've been meaning to ask for a while and never got > round to it... Is there a simple one line way to erase / clear a UDT > after its finished with, as opposed to clearing the variables within > it individually? Not that I know of. But you define a global variable as your UDT. This will, of course, be empty. Then, when you need to "reset" your local variable, set it to the global variable: Dim tLocal As MARK <do stuff> tLocal = tEmpty /gustav -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com