[MS_AccessPros] Change text box backstyle to transparent

 

Hello all,

I have a text box with a click event that opens a query. The reason the text box has a click event is because I have a dCount expression for the query and wanted to know how to change the backstyle to transparent after the user clicks the text box. Right now when I click the text box the query opens up but the text box has a white backstyle. The text box is set to be transparent as a default.

Any help would be appreciated.

Thank You

Jim Wagner

I have this code currently.

Private Sub txtqryFindDuplicatesForSCHEDULEDATA_Click()
DoCmd.OpenQuery "qryFindDuplicatesForSCHEDULEDATA", acViewNormal
Me.txtqryFindDuplicatesForSCHEDULEDATA.BackStyle = 0
End Sub

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___