James

Thanks for your clarrification on data types (too many possibilities
compared to xbase languages !)

However still have an issue in that whilst one can see the public variable
in the watch window any attempt to change it such as

PublicVar = Value

only results in a new variable scoped to that procedure being created but
doesn't alter the public variable

TIA

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"


"jamescox" wrote:


Ken -

You've got a problem in the IF statement: the test you are using

VarType(CH_Row) = vbNull

is checking the _type_ of variable CH_Row has been declared to be, not
the value it has. An integer (or any numeric variable) to which a value
has not yet been assigned has a value of zero.

So, if you meant to check if a value for CH_Row has been set in Sub
ColsHideKen, a more appropriate test would be


If CH_Row = 0 Then

Note that, as you assumed, once CH_Row has been set to zero the user
will never again be presented with the input box - unless you set CH_Row
back to zero once you do whatever ColsHide is supposed to do (or hide).

Hope this helps! :Bgr


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121274