asked on

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.....

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

INSCNOC

ASKER

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.....

INSCNOC

ASKER

I will try to use your advise on a Textbox, how to you "Flash" the control?

als315

Here is example:
http://www.techonthenet.com/access/forms/flashing.php

Scott McDaniel (EE MVE )

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