display message in text box

T

ttfo

I have a module that will display a message in a text box of a form. When I
"step" through the program using debugger, it work ok. When I run it
normally, the first message never appears in the text box. The 2nd,3rd... all
appear ok. It is just the first one. Anyone have any ideas?
 
D

Douglas J Steele

Without seeing the code in question, it'll be difficult for anyone to say.

Do you perhaps need a Me.Refresh or Me.Repaint?
 
T

ttfo

Doug,
I tried me.refresh and me.repaint and got error messages.
What is the proper syntax?

here is the code:
The name of the form is precipts
the name of the text box is statusmess


Set rst1 = db.OpenRecordset("DCSTbl")
Set rst2 = db.OpenRecordset("ReportTbl")
Forms![precips_entry]![StatusMess] = "Clearing Out Old Tables And Data !!!"
Me.Repaint
' Delete Temp Tables from previous import


Thanks,
Tony
 
D

Douglas J. Steele

What error did you get?

Where's the code located: in the module associated with a form, or in a
stand-alone module? Since you appear to be referring to the form as
Forms![precips_entry], try:

Forms![precips_entry].Repaint

Sometimes using DoEvents can help as well.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


ttfo said:
Doug,
I tried me.refresh and me.repaint and got error messages.
What is the proper syntax?

here is the code:
The name of the form is precipts
the name of the text box is statusmess


Set rst1 = db.OpenRecordset("DCSTbl")
Set rst2 = db.OpenRecordset("ReportTbl")
Forms![precips_entry]![StatusMess] = "Clearing Out Old Tables And Data
!!!"
Me.Repaint
' Delete Temp Tables from previous import


Thanks,
Tony

Douglas J Steele said:
Without seeing the code in question, it'll be difficult for anyone to
say.

Do you perhaps need a Me.Refresh or Me.Repaint?
Click to expand...
Click to expand...
 
T

ttfo

Doug,
I changed the "me.repaint" to Forms![precips_entry].Repaint and it worked.

Thanks for the help!

Tony

Douglas J. Steele said:
What error did you get?

Where's the code located: in the module associated with a form, or in a
stand-alone module? Since you appear to be referring to the form as
Forms![precips_entry], try:

Forms![precips_entry].Repaint

Sometimes using DoEvents can help as well.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


ttfo said:
Doug,
I tried me.refresh and me.repaint and got error messages.
What is the proper syntax?

here is the code:
The name of the form is precipts
the name of the text box is statusmess


Set rst1 = db.OpenRecordset("DCSTbl")
Set rst2 = db.OpenRecordset("ReportTbl")
Forms![precips_entry]![StatusMess] = "Clearing Out Old Tables And Data
!!!"
Me.Repaint
' Delete Temp Tables from previous import


Thanks,
Tony

Douglas J Steele said:
Without seeing the code in question, it'll be difficult for anyone to
say.

Do you perhaps need a Me.Refresh or Me.Repaint?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I have a module that will display a message in a text box of a form.
When
I
"step" through the program using debugger, it work ok. When I run it
normally, the first message never appears in the text box. The
2nd,3rd...
all
appear ok. It is just the first one. Anyone have any ideas?
Click to expand...
Click to expand...
Click to expand...
 
Top