Taking the whole Input Mask Value not just what is entered

[mcdhappy80]

I have an input mask in one of my text box fields. The input mask has this value:

"Чл. 2. ст. 1. тачка "0"."

My problem is when I enter the value database saves only what was entered (a single number in range from 0-9) and not the entire text (and I need the entire text, with the entered number of course). Is there a way to save the entire input mask text along with the correct entered value?
Thank You

 

[Galaxiom]

Masks only save the text you type.

If the text is repeating you would not normally store it anyway. If you need to export it with the extra characters you would do this in a query and concatenate them in the query.

 

[mcdhappy80]

[SOLVED] Taking the whole Input Mask Value not just what is entered

Masks only save the text you type.

If the text is repeating you would not normally store it anyway. If you need to export it with the extra characters you would do this in a query and concatenate them in the query.

Thank You for the answer. I already have an idea how to solve this, I was just wondering if there was an easier way, as usual there isn't.
Thanks Again.

 

[Galaxiom]

I still wonder why you would want to record repetitive text that is included in every record.

 

[mcdhappy80]

I still wonder why you would want to record repetitive text that is included in every record.

Because the text You see in the input mask is the text needed on the report, but with the changed numeric value. I just wanted to make it easier for the users, to make as less as mistakes as they could, and to make it more readable for them while they fill the text boxes.

If there is a way to leave the input mask as is, store only numeric values, but read the whole thing (input mask text with the stored value) on the report I would be grateful to hear it.

Can I format the report field in order to be able to do this?

Thank You

 

[Galaxiom]

Can I format the report field in order to be able to do this?

Try using the same text in the Input Mask Property of the Control in the Report.

 

[missinglinq]

Or, on the Report, use an Unbound, calculated Textbox with the Control Source

="Чл. 2. ст. 1. тачка " & TargetField & "."

where TargetField is the name of the field holding the number that was inputted.

Linq ;0)>