Default Value (1 Viewer)

Mickster

Registered User.
Local time
Today, 11:26
Joined
Feb 10, 2005
Messages
38
Hi, I am trying to display a default value of 06 followed by 3 digits, that the user would enter in. Would this be done in the Input Mask, if so how?

Thanks
 

statsman

Active member
Local time
Today, 14:26
Joined
Aug 22, 2004
Messages
2,088
I am currently doing somthing similar.

Field1: default value 06
Field2: blank
Field3: blank set to not visible in properties

On the form: Field1 is displayed as 06, Field 2 is blank, Field 3 is not visible. You enter 009 into Field2
On the forms Before Update

[Field3]=([Field1]&[Field2])

Field3 now reads 06009

The only problem is it's saved as text.
 

ghudson

Registered User.
Local time
Today, 14:26
Joined
Jun 8, 2002
Messages
6,194
Use an input mask like this...

"06"000;;_

I dislike input masks because they tick the users off when their cursor is not at the start of the field. Search around for their is code that will place the users cursor at the start of the field when the user clicks on the field.
 

Users who are viewing this thread

Top Bottom