[Last Call] Learn how to a build a cloud-first strategyRegister Now


Access 2007 Form Control

Posted on 2011-10-30
Medium Priority
Last Modified: 2012-05-12
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.....
Question by:INSCNOC
  • 2
  • 2
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 37052865
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.

Author Comment

ID: 37052913
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.....

Author Comment

ID: 37052944
I will try to use your advise on a Textbox, how to you "Flash" the control?
LVL 40

Expert Comment

ID: 37053026
LVL 85
ID: 37053063
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
    Me.YourControl.Backcolor = vbRed
  End If
End Sub

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question