Default in Textbox

[drunkenneo]

I have a text box in Form which i need use should only enter the numbers:



for eg:
When new form appears SI [space]#### should be there and even user needs he or she can change SI to PI and enter the required data.

And the data should go as SI #### or PI #### in Table Backend. The Textbox is Unbound.

[June7]

Why don't you have this in two fields?

Maybe use input mask?

[drunkenneo]

In input mask i can get success of either SI or PI but not on both. Means when i apply "SI " 9999 its limited only for SI and PI cant be typed.

[June7]

Try: L"I "9999;0;_

[drunkenneo]

Indeed, but this list have IC and LH Also..

[June7]

Then better to use two fields and two controls. The letter part can be selected by combobox. The number part can be input mask in a textbox. If really must be one field, use code to concatenate values of the two controls.

[Missinglinq]

Indeed, but this list have IC and LH Also..

Also, it would be better if you gave us all pertinent data in your original post, rather than making us provide an answer for one scenario, then having it changed to another scenario, and so forth! Don't post

'...the data should go as SI #### or PI #### in Table Backend...'

when the reality is

'...the data should go as SI #### or PI #### or IC #### or LH #### in Table Backend...'


I agree with June7; you need to store this in two different Fields. You can always concatenate them for display purposes.

Linq ;0)>

[drunkenneo]

I have worked it out with two different Fields.