How do I detect a blank (space) character as the first character in the field?
C Charles Tam Dec 1, 2005 #1 How do I detect a blank (space) character as the first character in the field?
F fredg Dec 1, 2005 #2 How do I detect a blank (space) character as the first character in the field? Click to expand... 1) =IIF(Left([FieldName],1) = " ","It's a space","It's NOT a space") or... 2) =IIf(Asc([FieldName])=32,"It's a space","It's NOT a space")
How do I detect a blank (space) character as the first character in the field? Click to expand... 1) =IIF(Left([FieldName],1) = " ","It's a space","It's NOT a space") or... 2) =IIf(Asc([FieldName])=32,"It's a space","It's NOT a space")
R Rob Oldfield Dec 2, 2005 #3 Use the LTrim function. Charles Tam said: How do I detect a blank (space) character as the first character in the Click to expand... field?
Use the LTrim function. Charles Tam said: How do I detect a blank (space) character as the first character in the Click to expand... field?
