Calling Public Const on a Form

[mckenneyj]

In the middle of a Brain Cramp
Seems I have forgotten how to do this

I have defined a Module named basCompanyInfo
In the module are several Public Const
Public Const AName = "xyz"
Public Const AStreet = "123 easy street"
Public Const ACSZ = "city, st, 11111"
Public Const APhone = "PHONE: (555) 666-7777"
Public Const AFax = "FAX: (555) 666-8888"
Public Const AURL = "

http://www.mydomain.com/"

I need to be able to reference these constants on forms and reports
A little help would be appreciated

Thanks,
John McKenney
Work Hard... Play Harder

 

[alvechurchdata]

Use them just like a variable - but only the right hand side of an "=":

strName = AName

Just as a matter of style, most folk put constants in capitals and define the type of each constant:

Public Const ANAME As String = "xyz"

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[VBslammer]

I make global properties out of them:

Public Const APP_ICON As String = "MyApp.ico"

Public Property Get AppIcon() As String
  AppIcon = APP_ICON
End Property

Then on the form or report I can access them normally:

=AppIcon()

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[mckenneyj]

Thanks
Both worked great
But I opted for defining Public Property

Thanks,
John McKenney
Work Hard... Play Harder