Why Is Form Transparent ?

[Mike Thomas]

Access 2000

In a VBA module which imports data I am trying to display a splash form
which provides info as the routine progresses.

For some reason the form is transparent. I can see the form's border and
the caption, but the body of the form and the caption therein are
tranparent.

Here is the code:

Public Function ManageImportfromJVK() As Integer
ManageImportfromJVK = 1

DoCmd.OpenForm "splash"
Forms!splash.lblMain.Caption = "Bringing in JKV Data"
Forms!splash.Visible = True

.........

Is there a setting in the form I can change, or a parameter I can use when
opening the form which will make the body of the form visible?

Many thanks
Mike Thomas

 

[Dirk Goldgar]

Access 2000

In a VBA module which imports data I am trying to display a splash
form which provides info as the routine progresses.

For some reason the form is transparent. I can see the form's border
and the caption, but the body of the form and the caption therein are
tranparent.

Here is the code:

Public Function ManageImportfromJVK() As Integer
ManageImportfromJVK = 1

DoCmd.OpenForm "splash"
Forms!splash.lblMain.Caption = "Bringing in JKV Data"
Forms!splash.Visible = True

.........

Is there a setting in the form I can change, or a parameter I can use
when opening the form which will make the body of the form visible?

Many thanks
Mike Thomas

My guess is that after opening the form your code enters a loop of some
sort. Put a DoEvents statement after you've opened the form and set its
Caption, before entering the loop. You'll probably also want to put a
DoEvents statement inside the loop, if you're updating the form in any
way or allowing user interaction with it (a Cancel button, for example).

 

[Mike Thomas]

Many thanks Dirk,
That was it.
Mike Thomas

My guess is that after opening the form your code enters a loop of some
sort. Put a DoEvents statement after you've opened the form and set its
Caption, before entering the loop. You'll probably also want to put a
DoEvents statement inside the loop, if you're updating the form in any
way or allowing user interaction with it (a Cancel button, for example).

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[news.east.earthlink.net]

Check to see if the detail section of the forms visible property is set to
yes or true.
HTH