Display Variable/Constant Value on Text Box

[espua]

Hi all,

I tried to display a variable and constant onto a text box by putting =myvariable onto the data source of the text box. However, Access seems keep threating my variable as a data field and giving me error message. What to do with this?

 

[Mile-O]

You need to use a function to return the value of the constant

i..e

Const MyVal = 10

Function GetVal()
    GetVal = MyVal
End Function

Then, on your form use =GetVal()