Access 2007 Form Control

I want to have a form with a text box to be used as a flashing message box, which works fine, my only issue the form keeps going full screen and I only want it as a small box on top of the current open form, I have played with all the form control but no luck, any insight would be appreciated.....
INSCNOCAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you issuing any Maximize commands in the form's code? That would generally be the only reason this would occur.

Alternatively, if you need this on only ONE form, then you can just add a Textbox/Label to that form and "flash" that control.
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
INSCNOCAuthor Commented:
No I am not issuing a maximize connamd, I also turned off tabbed documents in access option, all I want is the current opened form to be full screen and the new form to be just a small text box overlayed on the current screen, as I am using it as a information process text box while all my VBA code is running, then I want to close it at the end of my VBA code.....
0
 
INSCNOCAuthor Commented:
I will try to use your advise on a Textbox, how to you "Flash" the control?
0
 
als315Commented:
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You use the form's Timer event, as suggested in the link by als315. To start a Form event, set the Interval property to something other than zero, then add code to the Form's Timer event. That code will fire every time the timer event is called - which is at each "interval". The Interval value is in milliseconds, so a value of 1,000 is 1 second.

To stop the timer event, set the Form's Interval back to 0.

So for example:

Sub Form_Timer()
  If Me.YourControl.BackColor = vbRed Then
    Me.YourControl.BackColor = vbBlack
  Else
    Me.YourControl.Backcolor = vbRed
  End If
End Sub
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.