does anybody know how to get text to show over a textbox. until the user doesn't enter the text box it will show instructions or a label perhaps. i have seen it on some samples and now i can't seem to locate it. i think this is an easy one. i need to save space on a continues form. i would like to get rid of the lables.
does anybody know how to get text to show over a textbox. until the user doesn't enter the text box it will show instructions or a label perhaps. i have seen it on some samples and now i can't seem to locate it. i think this is an easy one. i need to save space on a continues form. i would like to get rid of the lables.
thankx, but that will not do what i want. i want it to be in the box not the yellow message when the mouse hovers over. i want it to be in the text box, it hangs there until the user enters.
thankx, but that will not do what i want. i want it to be in the box not the yellow message when the mouse hovers over. i want it to be in the text box, it hangs there until the user enters.
Ok, perhaps on the got focus event you can have a lable pop up over the text box with instructions. I don't see a mouse hover even....I do see mouse down, move and up. Perhaps you can try some code there.
However the code should be something like this.
Make an lable..and set the visible properties to be invis until one of those events filre. Have text there, but invisable until you do one fo the above events.
exp
lblInstructions.Visible = True
or
lblInstructions.visible = false
If you want it to toggle you can do this
lblinstructions.visible = Not lblinstructions.visible
then make it unvisible once the mouse is moved or loses focus.
Private Sub txtDateWorked_Enter()
Me.lblDateWorked.Visible = False
End Sub
Private Sub txtDateWorked_Exit(Cancel As Integer)
If IsNull(Me.txtDateWorked) Then
Me.lblDateWorked.Visible = True
End If
End Sub
i guess if i would want to do this for all of my textboxes i would write a module. the pain is the naming conventions.
Private Sub txtDateWorked_Enter()
Me.lblDateWorked.Visible = False
End Sub
Private Sub txtDateWorked_Exit(Cancel As Integer)
If IsNull(Me.txtDateWorked) Then
Me.lblDateWorked.Visible = True
End If
End Sub
i guess if i would want to do this for all of my textboxes i would write a module. the pain is the naming conventions.
I have some ideas here, but can you confirm the following please:
1) The field labels that you have are currently in the form's header section - this is where they should be for a continuous form.
2) You would like a single text box that gives information for the current field selected
3) You do not need any formatting applied to this "help" text box. i.e. just standard text.
I have attached a sample, so that you can see what I have in mind.
Post back if you want to take this any further...
regards
Rod
I was off reading "War and Peace" (both literally and figuratively) in the 'Cooler......haven't read a spat like that for a long time - and who said it would'nt get de-railed?...........oops - sorry - I'm doing it now...Butting right out!....
I was off reading "War and Peace" (both literally and figuratively) in the 'Cooler......haven't read a spat like that for a long time - and who said it would'nt get de-railed?...........oops - sorry - I'm doing it now...Butting right out!....
I guess that is a great solution and i think i will use it. so thanx a lot.
However, i would like to share with you my frustration. i used selen's idea and i liked it a lot. i am just stuck with the continous form problem. i have some complicated solutions which people posted on the web, but the solutions are way to complicated. I would like to figure out the following: (copy of my MSDN post)
I have a Continuous (bounded) Form where the users opens to New Entry
(DataEntry=True), then i have in the Form header three fields (unbounded)
which change the recordsource to a query based on the user's parameters. so
if the user enters 1, 2, or 3 parameters the form will show those matching
entries, and if the user then clears 1, 2 and 3 then only a new entry
(dataEntry=true) will show.
here is the issue, in order to economize on space i would like floating
lables that disappear when the user enters information. i wlll paste now a
sample of what happenes:
Code:
Private Sub cboAgencyID_Enter()
Me.lblAgencyID.Visible = False ' this is the label. it will disappear.
End Sub
Private Sub cboAgencyID_Exit(Cancel As Integer)
If IsNull(Me.cboAgencyID) Then ' if there is information, then we don't
a label
Me.lblAgencyID.Visible = True ' the label will appear
Else
Me.lblAgencyID.Visible = False ' the label will disappear
End If
End Sub
all works fine. its just when i show all fields, these labels are hard to
hide. i have seen some solutions on the web working with Continuous Forms. i
would like the following: only if i am showing a new record then i want these
labels to show, otherwise i don't need lables.