access 2007 public property get

A

ag20

I am having a problem between access 2007 and 2003. In vbcode I set up a
property "bla" using Public Property Get and Public Property Let. I have a
text box that has its control source as the property "bla". In 2003 every
thing works ok but in 2007 the text box cannot seem to read the property.
Here is the control source for the text box:

=[bla]

And here is the vbcode:

Option Compare Database

Dim vName As String

Public Property Let bla(iName As String)
vName = iName
End Property

Public Property Get bla() As String
If vName = "" Then
bla = "bill"
Exit Property
End If
bla = vName
End Property

Private Sub Command0_Click()
bla = "george"
Me.Refresh
End Sub

Is there something else I have to do to get 2007 to be able to read this
property directly into a text box?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top