space in an input mask

[Paul]

hi,

is there an input mask i could use on a report to do the following:

(1) if i enter "THISISATEST" on my form, i want
the text box on my report to display: "T H I S I S A T E S T".

(2) if i enter "THIS IS A TEST" on my form, i want
the text box on my report to display: "T H I S I S A T E ST".

i tried putting in the input mask, "A A A A A A A A A A A A A", but
it only works when there no spaces in between letters or words [i.e.
refer to example (1)]. when i do example (2), i don't the result i want. it
ignores the spaces i put in the form and displays it as it is "THIS IS A
TEST".

i'm trying to properly line-up the characters on an pre-existing paper form.
example the paper has the following format:

Name: | | | | | | | | | |
|

i want to properly space the characters so that it will line up properly on
the form.

any ideas would be appreciated. feel free to send me email directly.
thanks in advance.

Paul

 

[Duane Hookom]

Are you printing the form or a report. I would suggest that you enter the
value as in the form and store it that way. Use a custom function in the
control source of a report text box to display the value with extra spaces.