R
rogers
what function do you use (eg in an IIfmnested expression)
to discover if a textfield is NOT null?
to discover if a textfield is NOT null?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gerald Stanley
You still use the IsNull() function e.g.
IIf(IsNull(variable), code for null, code for not null)
Hope This Helps
Gerald Stanley MCSD
IIf(IsNull(variable), code for null, code for not null)
Hope This Helps
Gerald Stanley MCSD
V
Van T. Dinh
IF Not IsNull([TextField]) THEN ...
However, I prefer to use:
IF Len([TextField] & "") > 0 THEN ...
which eliminate both Null and zer0-length String.
If you use imported data (which can have values with white spaces only),
use:
IF Len(Trim$([TextField] & "")) THEN ...
However, I prefer to use:
IF Len([TextField] & "") > 0 THEN ...
which eliminate both Null and zer0-length String.
If you use imported data (which can have values with white spaces only),
use:
IF Len(Trim$([TextField] & "")) THEN ...
D
david epsom dot com dot au
Typographical error.... should have been:
IF Len(Trim([TextField] & "")) THEN ...
(david)
IF Len(Trim([TextField] & "")) THEN ...
(david)
Van T. Dinh said:IF Not IsNull([TextField]) THEN ...
However, I prefer to use:
IF Len([TextField] & "") > 0 THEN ...
which eliminate both Null and zer0-length String.
If you use imported data (which can have values with white spaces only),
use:
IF Len(Trim$([TextField] & "")) THEN ...
--
HTH
Van T. Dinh
MVP (Access)
rogers said:what function do you use (eg in an IIfmnested expression)
to discover if a textfield is NOT null?
V
Van T. Dinh
--
HTH
Van T. Dinh
MVP (Access)
HTH
Van T. Dinh
MVP (Access)
david epsom dot com dot au said:Typographical error.... should have been:
IF Len(Trim([TextField] & "")) THEN ...
(david)
Van T. Dinh said:IF Not IsNull([TextField]) THEN ...
However, I prefer to use:
IF Len([TextField] & "") > 0 THEN ...
which eliminate both Null and zer0-length String.
If you use imported data (which can have values with white spaces only),
use:
IF Len(Trim$([TextField] & "")) THEN ...
--
HTH
Van T. Dinh
MVP (Access)
rogers said:what function do you use (eg in an IIfmnested expression)
to discover if a textfield is NOT null?
V
Van T. Dinh
Actually, I did mean:
IF Len(Trim$([TextField] & "")) THEN ...
Trim returns a Variant (of String type) while Trim$ returns a String.
--
HTH
Van T. Dinh
MVP (Access)
IF Len(Trim$([TextField] & "")) THEN ...
Trim returns a Variant (of String type) while Trim$ returns a String.
--
HTH
Van T. Dinh
MVP (Access)
david epsom dot com dot au said:Typographical error.... should have been:
IF Len(Trim([TextField] & "")) THEN ...
(david)
Van T. Dinh said:IF Not IsNull([TextField]) THEN ...
However, I prefer to use:
IF Len([TextField] & "") > 0 THEN ...
which eliminate both Null and zer0-length String.
If you use imported data (which can have values with white spaces only),
use:
IF Len(Trim$([TextField] & "")) THEN ...
--
HTH
Van T. Dinh
MVP (Access)
rogers said:what function do you use (eg in an IIfmnested expression)
to discover if a textfield is NOT null?
D
david epsom dot com dot au
Actually, I did mean:
???????
Len(Trim$([TextField]) & "")
returns a type conversion error for [TextField] is null
Len(Trim([TextField] & ""))
returns FALSE for [TextField] is null
If in some version of VBA "Trim$(Null)" returns an empty string, then
& ""
would not be required.
(david)
???????
Len(Trim$([TextField]) & "")
returns a type conversion error for [TextField] is null
Len(Trim([TextField] & ""))
returns FALSE for [TextField] is null
If in some version of VBA "Trim$(Null)" returns an empty string, then
& ""
would not be required.
(david)
Van T. Dinh said:Actually, I did mean:
IF Len(Trim$([TextField] & "")) THEN ...
Trim returns a Variant (of String type) while Trim$ returns a String.
--
HTH
Van T. Dinh
MVP (Access)
david epsom dot com dot au said:Typographical error.... should have been:
IF Len(Trim([TextField] & "")) THEN ...
(david)
Van T. Dinh said:IF Not IsNull([TextField]) THEN ...
However, I prefer to use:
IF Len([TextField] & "") > 0 THEN ...
which eliminate both Null and zer0-length String.
If you use imported data (which can have values with white spaces only),
use:
IF Len(Trim$([TextField] & "")) THEN ...
--
HTH
Van T. Dinh
MVP (Access)
what function do you use (eg in an IIfmnested expression)
to discover if a textfield is NOT null?
D
david epsom dot com dot au
Ok, now (to late) I see _my_ error.
(david)
(david)
david epsom dot com dot au said:???????Actually, I did mean:
Len(Trim$([TextField]) & "")
returns a type conversion error for [TextField] is null
Len(Trim([TextField] & ""))
returns FALSE for [TextField] is null
If in some version of VBA "Trim$(Null)" returns an empty string, then
& ""
would not be required.
(david)
Van T. Dinh said:Actually, I did mean:
IF Len(Trim$([TextField] & "")) THEN ...
Trim returns a Variant (of String type) while Trim$ returns a String.
--
HTH
Van T. Dinh
MVP (Access)
david epsom dot com dot au said:Typographical error.... should have been:
IF Len(Trim([TextField] & "")) THEN ...
(david)
IF Not IsNull([TextField]) THEN ...
However, I prefer to use:
IF Len([TextField] & "") > 0 THEN ...
which eliminate both Null and zer0-length String.
If you use imported data (which can have values with white spaces only),
use:
IF Len(Trim$([TextField] & "")) THEN ...
--
HTH
Van T. Dinh
MVP (Access)
what function do you use (eg in an IIfmnested expression)
to discover if a textfield is NOT null?