Force Label to front

[Guest]

Hi,

Is there anything available to enable me to force a label or text box
infront of an active combo-box?
I have a small sub-form (pop-up & modal) to display contacts for a given
customer and want the 1st tab combo-box that contains the numerous contacts
to effectively display 'or Leave Blank to Enter New' or similar, but as the
combo receives the focus on opening the form I can find no way of making
anything visible regardless of 'bring to front' properties or format
properties such as make 'transparent' etc. and I have yet to find a customer
that actually reads 'Status Bars' or 'Control Tip Text's.

thx in advance,

 

[Guest]

There is a much better approach. Go to this web site to get info on how to
configure your combo box. It would be just as easy to use "NEW" as to use
"ALL" as shown in the examples:
http://www.mvps.org/access/forms/frm0043.htm

Then in the After Update event of the Combo Box, Check to see if "NEW" was
selected, and do whatever you want from there.

 

[Guest]

Unfortunately the Bound column is the Primary Key of the underlying table and
has a field width of 0 which seems to prohibit the use of this method.

TonyT

 

[Guest]

Not true, go back and read the site again. It specifically addresses that
issue.

 

[Guest]

seems i'm getting confused here, I read '(if the bound field is not the
primary key of the table),' to preclude what i'm trying.

Is there really no way of achieving what I originally asked for, as the
coding would get cumbersome due to the fact that the recordsource for the
combo box has 3 different options depending on other criteria and is drawn
form 3 or 4 inner joins written on the fly in the forms on_Open event and
then provides the recordsource for the whole sub-form.

All i'm after is a label to the front of a combobox!!

TonyT

 

[Brendan Reynolds]

Hi Tony,

It is notoriously difficult to prove a negative, but to the best of my
knowledge I believe the answer is that there really is no way of achieving
what you originally asked for, i.e. for the label to be in front of the
combo box when the combo box is 'active', i.e. when it has focus.

Re customers not reading status bar or control tip text - I place a large,
bold label on my forms and set the caption of the label equal to each
control's StatusBarText property, in the Enter event of each control.
Unfortunately, it seems most users don't see the big bold label, either! :-(

 

[Guest]

Thanks Brendan,

I like the Bold Label idea - i may well adopt this strategy as 3 chances has
got to be better than 2!!!

TonyT

 

[Guest]

Hi again,

Have just been playing around with your idea for label and created a textbox
called txtTip, set key preview to Yes and then added;

Private Sub Form_KeyPress(KeyAscii As Integer)
Me![txtTip] = Screen.ActiveControl.StatusBarText
End Sub

doesn't of course pick up mouse movements, but with control tips as
well.......
here's hoping!
Tony

 

[Brendan Reynolds]

I've often wished that forms had a Mouse Preview property! :-(

It can be done with the Timer event, but I've never been comfortable with
the idea of executing code every second or so if I don't really need to.

--
Brendan Reynolds

Hi again,

Have just been playing around with your idea for label and created a
textbox
called txtTip, set key preview to Yes and then added;

Private Sub Form_KeyPress(KeyAscii As Integer)
Me![txtTip] = Screen.ActiveControl.StatusBarText
End Sub

doesn't of course pick up mouse movements, but with control tips as
well.......
here's hoping!
Tony

Hi Tony,

It is notoriously difficult to prove a negative, but to the best of my
knowledge I believe the answer is that there really is no way of
achieving
what you originally asked for, i.e. for the label to be in front of the
combo box when the combo box is 'active', i.e. when it has focus.

Re customers not reading status bar or control tip text - I place a
large,
bold label on my forms and set the caption of the label equal to each
control's StatusBarText property, in the Enter event of each control.
Unfortunately, it seems most users don't see the big bold label, either!
:-(