Why Is Form Transparent ?

  • Thread starter Thread starter Mike Thomas
  • Start date Start date
M

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
 
Mike Thomas said:
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).
 
Many thanks Dirk,
That was it.
Mike Thomas
Dirk Goldgar said:
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)
 
Check to see if the detail section of the forms visible property is set to
yes or true.
HTH
 
Back
Top