blank form

[ryetee]

I have a form which I load when I have some processing taking place which may take some time. This form has a label on it with the caption "Processing taking place please wait." The form is called "PleaseWait"

In VBA I have
DoCmd.OpenForm "PleaseWait"

Some code which make take a while to process.

DoCmd.Close acForm, "PleaseWait"

The form pops up as expected but the form is blank.
I have tried changing the caption in the on load
ie
Me.label.caption = "Processing taking place please wait."
I've tried putting an unbound text box in there as well
Me.textbox = " "Processing taking place please wait."
I've also tried
Me.textbox.vale = " "Processing taking place please wait."

Each time I get a blank form
And yes each control is visible
Any ideas what could be happening?

 

[pbaldy]

You might try adding

DoEvents

after the OpenForm. Alternatively, just open the form, and in its timer event run your code, then close the form.

 

[ryetee]

You might try adding

DoEvents

after the OpenForm. Alternatively, just open the form, and in its timer event run your code, then close the form.

When you say add Doevents after the openform would that be in the On OPen event?

I use the form for a number of places where I want to highlight tothe user that processing may take some time so adding code in means I'deither have to have separate wait forms or pass some sort of parameter to say which code to run. I'll try it if nothing else comes along but I'd like my code in a more 'logical' place.

 

[pbaldy]

No I meant right after the OpenForm language line.

 

[MarkK]

A form may show up blank if it is bound to a RecordSource that returns no records and AllowAdditions = False.

 

[ryetee]

You might try adding

DoEvents

after the OpenForm. Alternatively, just open the form, and in its timer event run your code, then close the form.

Cheers pbaldy works a treat!

 

[ryetee]

A form may show up blank if it is bound to a RecordSource that returns no records and AllowAdditions = False.

Yes I saw that but this is literally an unbound form to display a "please wait for processing".

pbaldy suggested sticking in doevents after the open which works...

 

[pbaldy]

Happy to help!