data validation and null text

's Computer Specifications

Is there a method (no macro) to prevent that when editing a cell it
cannot contains a null (blank) text?
I have tried with cell A1 inserting the following formula in Data
validation: "=(LEN(A1)>0)" but it does not work.

's Computer Specifications

Uncheck the ignore blank checkbox as well.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Scarababau" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is there a method (no macro) to prevent that when editing a cell it
> cannot contains a null (blank) text?
> I have tried with cell A1 inserting the following formula in Data
> validation: "=(LEN(A1)>0)" but it does not work.
>

's Computer Specifications

Did you uncheck the "Ignore Blank" checkbox in the Validation dialog?

In article <(E-Mail Removed)>,
"Scarababau" <(E-Mail Removed)> wrote:

> Is there a method (no macro) to prevent that when editing a cell it
> cannot contains a null (blank) text?
> I have tried with cell A1 inserting the following formula in Data
> validation: "=(LEN(A1)>0)" but it does not work.

's Computer Specifications

> Uncheck the ignore blank checkbox as well.

Unchecked, but it does not work the same...

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show null and non null data	=?Utf-8?B?U3RvY2t3ZWxsNDM=?=	Microsoft Access Reports	0	24th Jul 2007 03:36 PM
Syntax error - =IIf(text Like "0?", "", text) --- =IIf([text] = "0?", Null, "Some Caption Text")	Ixak	Microsoft Access Reports	8	15th Dec 2006 08:58 AM
Empty text values aren't null or zero-length, but 2-byte null (\x0000)	Mark Steward	Microsoft Access	2	21st Jan 2006 03:03 PM
Null text box fields when group heading is null	Richard Harison	Microsoft Access Reports	8	1st Jul 2005 01:24 PM
Null result when combining null field with non-null field in ADP View	Lauren Quantrell	Microsoft Access Form Coding	8	17th Nov 2003 03:34 AM