Access 2007 Form Control

Posted on 2011-10-30
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
    LVL 84

    Accepted Solution

    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

    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

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

    Expert Comment

    LVL 84
    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    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.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now