Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Variable (col type)

Status
Not open for further replies.

MikeKeane

Programmer
Sep 5, 2001
13
GB
Hi,
can anyone tell me how to find out the variable type in VBA?
i need to know whether it is a number or string that is being returned by the dataprovider (column type)

Any help on this would be appreciated.
Thanks
 
What are you using for a dataprovider?. Using a universe will simply be a question of checking up the datatype in the properties of an object. In other cases look at the table definition in the database directly (or ask a DBA to do that for you). At report level you can distill the datatype from applying a couple of functions like TO_CHAR, FORMAT_NUMBER etc and watch what happens..... T. Blom
Information analyst
tbl@shimano-eu.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top