i'm sure it's been asked before, but i am trying to display a form while i build
a report, but all that's visible is he form caption. it works good enough if i
put the message in the caption, but why does the form show a white background
and no label when it is displayed?

--


Gary

Gary,
If you are running intensive code, you may not be giving Excel the
opportunity to repaint the form. Adding a DoEvents in a suitable place will
yield some time to other causes.

NickHK

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i'm sure it's been asked before, but i am trying to display a form while i
build
a report, but all that's visible is he form caption. it works good enough
if i
put the message in the caption, but why does the form show a white
background
and no label when it is displayed?

--


Gary

thanks, nick. worked fine

--


Gary


"NickHK" wrote in message
...
Gary,
If you are running intensive code, you may not be giving Excel the
opportunity to repaint the form. Adding a DoEvents in a suitable place will
yield some time to other causes.

NickHK

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i'm sure it's been asked before, but i am trying to display a form while i
build
a report, but all that's visible is he form caption. it works good enough
if i
put the message in the caption, but why does the form show a white
background
and no label when it is displayed?

--


Gary