Trevor
04-16-2008, 01:54 PM
I'm tryin to align text to the left side of the label instead of right and not having any luck
Dim Clstrsub as string
Dim strcls As String
ClstrSub = Nz(DLookup("[Setting]", "SettingsTbl", "[VarSettingName] = 'Cluster Sub Label'"), "none") ' lookup value to place in label88
Me.[Label88].Caption = Trim(ClstrSub) & ":" place value in label88 and remove leading and trailing spaces
' I have tried label88 = left(clstrsub) ' error arg not allowed
' left(label88) no luck same error
' I have also tried with no luck
strcls = len(clstrsub)
Left(label88, strcls)
Thanks for helping in advance
Dim Clstrsub as string
Dim strcls As String
ClstrSub = Nz(DLookup("[Setting]", "SettingsTbl", "[VarSettingName] = 'Cluster Sub Label'"), "none") ' lookup value to place in label88
Me.[Label88].Caption = Trim(ClstrSub) & ":" place value in label88 and remove leading and trailing spaces
' I have tried label88 = left(clstrsub) ' error arg not allowed
' left(label88) no luck same error
' I have also tried with no luck
strcls = len(clstrsub)
Left(label88, strcls)
Thanks for helping in advance