What's difference between Mid and Mid$. Same question as Left and Left$
K Ken Snell Jan 19, 2004 #2 From a recent reply by Allen Browne (ACCESS MVP): Mid$() returns a String Variable. Mid() returns a Variant. Mid$() will be more efficient when working with strings in VBA code. Mid() is the only choice when working with fields, because a field might be Null and strings cannot be Null.
From a recent reply by Allen Browne (ACCESS MVP): Mid$() returns a String Variable. Mid() returns a Variant. Mid$() will be more efficient when working with strings in VBA code. Mid() is the only choice when working with fields, because a field might be Null and strings cannot be Null.
