[AccessD] the value of Access constants

On 4 Dec 2003 at 22:48, John W. Colby wrote:

> I need to know the value of the constants acFormatSNP, acFormatRTF etc.  If
> I go to the debug window and input:
> 
> ?acFormatSNP
> 
> I get:
> 
> Snapshot Format (*.snp)
> 
> I need the actual integer (or long?) value of the constant so I can store it
> in a lookup table and allow selecting the kind of report I want using the
> docmd.outputto.
> 
> Does anyone know how to see the actual numeric value of this thing?
> 

Doesn't have one. It's a text constant, not a numeric.
acFormatSNP =  "Snapshot Format (*.snp)"

Open the VBA Object Browser Window and look at Access.Constants
All the acFormatxxx constants are listed as string values.

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.