[RESOLVED] msoFalse constant

[whiteWay]

I am coding the creation of a Word document in Access XP and the compiler is choking on the msoFalse constant....

.Selection.ShapeRange.ScaleWidth 0.37, msoFalse, msoScaleFromTopLeft

because it is not defined.

Just keep my code clean, I want to fix this. I believe the soluction is just to figure out what the parent object of the constant is. However, I am having trouble finding it.

Anyone know or have an alternate solution?

[Static]

did you add the reference to MS Word? or are u using createobject("Word....?

if u add the reference access will know what mso is.. if u dont want to (so its more compatable) then do this:

open Word
Hit ALT+F11
then Hit F2
That should bring up the object browser
in the search box (Second combo down - top left)
type msoFalse
it will bring up the msoFalse ... look in the lower left you will see:
Const msoFalse = 0
there is your value..

go back to access and add that into a module
repeat for any others like
Const msoScaleFromTopLeft = 0

[whiteWay]

Thanks Static,

Didn't even think of using the objects brower to find that out.