Using a Public Const in a report 1

[Binnit]

I have declared a public const in a module which works fine using the intermediate window.

I want to use this constant in a control on a report but it does not recognise it.

Can someone tell me why or how I can get it ona report.

Thanks

Happiness is...not getting what you want but wanting what you have already got

 

[dhookom]

Create a small user-defined function that returns the constant. Then set a control source of a text box to the function:

Public Function GetConstant() as String
    GetConstant = cstrMyConstant
End Function

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Binnit]

dhookom
Great stuff... simple when you know how

Thanks

Happiness is...not getting what you want but wanting what you have already got