Input masks!!

davesmith · Jul 10, 2001

I'm trying to enter fields in a certain fashion, one being (although not the only one) sort codes for client bank details.

The field should contain a 6 character record, i.e. being 141265.
This is then displayed in the for as 14-12-65, how!!!

And i need it to be entered in this fashion too, yet to record only the six digits.

As i've said before, i'm a cross-over Access coder, this was easily done in that, i'm at a loss in this (and i think my boss is booking me in for a roasting!!, these deadlines!!)

Cheers

Dave

Gamera99 · Jul 10, 2001

Well once you have the data 14-12-65 in the text box,
you can replace the "-" with nothing:

strText = Replace(textbox.value, "-", "&quot

and save "strText" (which now looks like "141265&quot

to your database. You can also do some validations to make sure the length is right, not null, etc.

davesmith · Jul 10, 2001

Shtop, Shtop, We have a misunderstanding.

I want all i want to know is how to accept/display data in a certain format.

In access i would go into the Input Mask and type (for this same code 12-12-12)

00-/00-/00, this would put the number in the field as 121212 but would accept entry 121212 and split it as its entered with -,

Just like if someone was entering a date but you were saving it as text, such as 14102000, you can do it so it shows as 14/10/2000, But this too, i do not know how to do (although i know it is possible).

Any help is appreciated, its not how the data is saved, but only how it appears on the screen.

Cheers

Dave

dianal · Jul 10, 2001

Hello,
In Access you have very nice tool for input mask.
In web page, you are on your own to do the masking.
You have to take care of everything - what user inputs, what events happened and so on.
See an exemplary code with JavaScript
<HTML>
<HEAD>
<script>
function propershow(val){
val = val.toString();
if (val.indexOf("/&quot

== -1) {
document.forms[0].txtVal.value = val.substr(0,2) +"/" + val.substr(2,2) +"/" + val.substr(4,2)
}
}
</script>
</HEAD>

<BODY>
<form>
<input name="txtVal" type="text" onClick="propershow(this.value)" onBlur="propershow(this.value)" value="mm/dd/yy">
</form>
</BODY>
</HTML>

Play with it.
Also it would be helpful if you post yor quetsion in JavaScript forum.
D.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Input masks!!

davesmith

IS-IT--Management

Gamera99

Programmer

davesmith

IS-IT--Management

dianal

Instructor

Similar threads

Part and Inventory Search

Sponsor