Determining Data Types

Nancy

Guest

Posts: n/a

25th Sep 2003

In my VBA/Access Application, I am trying to get rid of
null values in a recordset I have just created. What I
would like to do is loop through the recordset and set
the values to "", 0, 12:00:00 AM, depending on whether
the data type of the field is text, currency, or date. I
could do it the long way and go through each field in the
recordset, but I would like to know if there is an easier
way in which I can determine datatype and then go from
there.

Thanks!

« Lock the code w/o locking out the user??? | Find Method »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Determining the text mode from a variety of data types	matt3542	Microsoft Excel Worksheet Functions	17	31st Jul 2008 08:01 PM
determining drive types	=?Utf-8?B?R3JlZ1Q=?=	Microsoft Dot NET	7	9th Mar 2005 09:45 AM
Dynamically determining C# data types from empty Database tables	=?Utf-8?B?RmlzaE5CcmV3RHVkZQ==?=	Microsoft ADO .NET	2	31st May 2004 04:01 PM
Re: Determining Data Types	Van T. Dinh	Microsoft Access VBA Modules	0	26th Sep 2003 12:41 AM
Determining Data Types	Peter	Microsoft Access VBA Modules	0	25th Sep 2003 09:53 PM