ACCESS FEED: Re: [MS_AccessPros] Change text box backstyle to transparent

Senin, 31 Desember 2012

Re: [MS_AccessPros] Change text box backstyle to transparent

John,

Thank You. That works great now.

Jim Wagner
________________________________

________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, December 31, 2012 10:33 AM
Subject: RE: [MS_AccessPros] Change text box backstyle to transparent

Jim-

I think it's the BackColor property you want to set.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Monday, December 31, 2012 5:26 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [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

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]