convert property TYPE to ENUM

[ajetrumpet]

would anyone know how to convert the TYPE property of an actual FORM'S property to it's literal ENUM string value?

example:

with forms("form1")

   debug.print .properties("modal").type

end with

that code will print the value "11" in the immediate window because the ENUM constant name is "dbBoolean".



What I'm looking for is a way to convert the return value of "11" to the actual constant NAME ("dbBoolean"). Anyone got any experience? Thanks!

[DaveT]

Best I can tell, you just have to write a SELECT CASE routine, pass it the number and have it return the equivalent string.

BTW, I get dbBoolean as = 1

You might look at Access help for DataTypeEnum Enumeration.

[ajetrumpet]

yes dave,

thanks for the suggestion. I found out that I can do just that with the VarType() function. forgot that was available. thanks!

[DaveT]

Yes, I forgot about vartype (duh). And vbBoolean is 11.

If Microsoft keeps pushing macros and "intellisense" before long none of us will know how to program VBA ...

[ajetrumpet]

Yes, I forgot about vartype (duh). And vbBoolean is 11.

If Microsoft keeps pushing macros and "intellisense" before long none of us will know how to program VBA ...

Yeah right...no kidding. Unfortunately I think that's another attempt from the "powers that be" to keep the knowledge out of the hands of the less fortunate. maybe not thought. I think we're going to see a big change if MS keeps doing this though. We can't stop using their products due to their power, but there are other things that we can do.

It'll be interesting to see what happens from the people.