Public variable problem

Thanks .

I wrote [A] in the Default Value property.
Are you saying that, this does not work in 2010 and must be written as """" & [A] & """" ??
 
I have attached a modified version of ChrisO's database.

Form 1, Setting the Default Property of field Text0 to ="""" & [A] & """" on the Property Sheet.

Access 2003: "ABC" (Incorrect)
Access 2010: #Name (Incorrect)

Form 2, using VBA to set the default of Text0
Me.Text0.DefaultValue = """" & A & """"

Access 2003: ABC (Correct)
Access 2010: ABC (Correct)
 

Attachments

Thanks a lot.

Cheers
 
I thought it was worth doing a comparison so I powered up my old sub notebook, which has Windows XP and Access 2003 on it, and waited .... :(

and waited ... :banghead:

and waited ... :D

Anyway, I'm glad it proved useful. :)
 

Users who are viewing this thread

Back
Top Bottom