Checking for empty strings

[Geoff]

If I want to check a string variable for lack of content, I usually use:

If Trim($var) = vbNullString...

(There is probably a better way to do it, but I have used this in so many places .....)

I have now hit a problem with some strings that have to be of fixed length and trimming doesn't change that. So:

dim $var as String * 25
If Trim($var) = vbNullString ...

will always return "False" because if it doesn't contain anything else, $var will contain 25 spaces.

Is there any way to check for this state other than comparing it to a string of 25 spaces?

TIA

Geoff

[ranman256]

A trim of string does not produce NULL. It will = "" (empty set)

[Geoff]

You can check for an empty thread by checking for vbNullString. Not Null. vbNullString works as equal to ""

But my question remains the same. Where the string is stuck at a certain number of spaces because it is a fixed length string, is there an easy way to check that it is just a string of spaces of that length?

Geoff

[macropod]

If (Len(StrString) = 25) And (Trim(StrString) = vbNullString) Then ...

[Geoff]

Many thanks