StatusBox - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

StatusBox

William Farrar

5 years ago

In the video posted on Jan. 25, 2021 "Context-Sensitive Help", the video shows different ways to provide help to the users. After watching several of your videos, I decided on using the StatusBox item that is used in the Template. The issue I'm having, is that each call to the Stats Function, creates another line in the box. My temporary solution is to resize the box so that only one line is displayed to the user, keeping the other lines hidden. I have also used some properties that have been mentioned in other videos, but they will be evident in the small database that I'll bee emailing to you
I

	Scott Axton @Reply 5 years ago
Just clear the status box before issuing the next status: StatusBox = "" Also, please see Access Forum Posting Rules

William Farrar OP @Reply

5 years ago

When I tried the StatusBox = "" it just places a space between the lines and does not erase the previous line!

I was looking for a VBA solution instead. I'm using the StatusBox for a "helper". When the cursor is on the FirstName Field, "Please enter the First Name" appears in the StatusBox. When the user tabs or presses the enter key, the focus goes to the next field (LastName). Then, automatically the BackColor changes to RGB(255, 255, 179), and the "Enter the Last Name appears in the StatusBox. This process continues throughout the form, except that the StatusBox grows with each flied. I want to ensure that the "correct" message appears in the StatusBox with each data entry'

	Alex Hedley @Reply 5 years ago
`StatusBox = StatusBox & " "` would add a space to the current value `StatusBox = ""` will clear it. Can you share your code or a screenshot to see what's going on.

	Scott Axton @Reply 5 years ago
Using your example above: S = "Please enter the First Name" StatusBox = "" StatusBox S

	Richard Rost @Reply 5 years ago
StatusBox is fully explained in the Contact Management video.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View