Assign Formula to Variable
James,
Try this
Length = Len(FileNumber4)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"James Stephens" wrote in message
...
I am sure this is simple but I can't figure our where I am going wrong,
here is what I have.
Length = Len(" & FileNumber4 & ")
I am trying to assign to the variable named "Length" the number of
characters in the variable named "FileNumber4"
Where am I going wrong, I have looked around and I though this should work
but the value for Length should end up as either a 5 or a 6 and it is
telling me it is 17. I am a little lost.
Thanks for the advice,
Jim
|