Tips we forget - required fields (1 Viewer)

CJ_London

Super Moderator
Staff member
Local time
Today, 18:09
Joined
Feb 19, 2013
Messages
16,553
Or perhaps it should be 'tips I'd forgotten';)

Prompted by another post on this forum, in an idle moment I dug out some of my early applications and was reminded of this tip

The format property has four states positive;negative;zero;text - and nulls are interpreted as text

so for required fields for example, format the relevant control as
;;;[Red]"This field is REQUIRED"

acts as a reminder to users (still doesn't take away the need to verify it has been completed)
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 11:09
Joined
Aug 30, 2003
Messages
36,118
Interesting; I knew about and have used the 4 states, but never thought to use them like that. Nice one. I assume that would only work for a numeric field? I use Conditional Formatting to highlight required but not yet complete fields.
 

spikepl

Eledittingent Beliped
Local time
Today, 19:09
Joined
Nov 3, 2010
Messages
6,144
and

@;"this is my prompt" ' works too, where the prompt is shown on Null
 

CJ_London

Super Moderator
Staff member
Local time
Today, 18:09
Joined
Feb 19, 2013
Messages
16,553
as I had it it works for number or text as far as the null is concerned
 

Users who are viewing this thread

Top Bottom