By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,584 Members | 3,447 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,584 IT Pros & Developers. It's quick & easy.

Help: Input Mask (with spce)

P: n/a
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 S
T".

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".

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

Paul
Nov 13 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
Try using an ampersand instead:

&/ &/ &/ &/ &/ &/ &/ &/

Paul

"Paul" <pc*******@yahoo.com> wrote in message
news:78**************************@posting.google.c om...
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 S
T".

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".

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

Paul

Nov 13 '05 #2

P: n/a
Do you really mean a forward slash (/) as opposed to back slash(\)?
I tried as you suggested, the slash came out. I tried it with a back-slash
and it's works the same way as C\ C\ C\ C\......Basically, it works okay
without space.

Also, I want to line up the field or entries on a pre-existing form.
When i put a double space in between (i.e. C\ C\ C\ \C or
&\ &\ &\)it just ignores it.

"Paul" <pz****@rogers.com> wrote in message news:<L9********************@rogers.com>...
Try using an ampersand instead:

&/ &/ &/ &/ &/ &/ &/ &/

Paul

"Paul" <pc*******@yahoo.com> wrote in message
news:78**************************@posting.google.c om...
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 S
T".

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".

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

Paul

Nov 13 '05 #3

P: n/a
Sorry about the slashes.

OK \ means only show the immediate character after the \. SO if you wanted
2 spaces your could do either:

"(PressSpaceBarTwice)"

or

\(PressSpacebar}\(PressSpacebar)

Both of these would perform the same results
C\ C\ \ C\ \ C

or

C" "C" "C" "C
"Paul" <pc*******@yahoo.com> wrote in message
news:78**************************@posting.google.c om...
Do you really mean a forward slash (/) as opposed to back slash(\)?
I tried as you suggested, the slash came out. I tried it with a back-slash
and it's works the same way as C\ C\ C\ C\......Basically, it works okay
without space.

Also, I want to line up the field or entries on a pre-existing form.
When i put a double space in between (i.e. C\ C\ C\ \C or
&\ &\ &\)it just ignores it.

"Paul" <pz****@rogers.com> wrote in message
news:<L9********************@rogers.com>...
Try using an ampersand instead:

&/ &/ &/ &/ &/ &/ &/ &/

Paul

"Paul" <pc*******@yahoo.com> wrote in message
news:78**************************@posting.google.c om...
> 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 S
> T".
>
> 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".
>
> any ideas would be appreciated. feel free to send me email directly.
> thanks in advance.
>
> Paul

Nov 13 '05 #4

P: n/a
Thanks for the tip but, I have tried this before but, it didn't work.
I was able to use this by spacing out the record that was already in
the database properly. However when I entered i new recordd it still
didn't spaced it properly. It's only spacing it out properly when i
don't put any spaces in between words (i.e. "THISISANEXAMPLE").

"Paul" <pz****@rogers.com> wrote in message news:<pO********************@rogers.com>...
Sorry about the slashes.

OK \ means only show the immediate character after the \. SO if you wanted
2 spaces your could do either:

"(PressSpaceBarTwice)"

or

\(PressSpacebar}\(PressSpacebar)

Both of these would perform the same results
C\ C\ \ C\ \ C

or

C" "C" "C" "C
"Paul" <pc*******@yahoo.com> wrote in message
news:78**************************@posting.google.c om...
Do you really mean a forward slash (/) as opposed to back slash(\)?
I tried as you suggested, the slash came out. I tried it with a back-slash
and it's works the same way as C\ C\ C\ C\......Basically, it works okay
without space.

Also, I want to line up the field or entries on a pre-existing form.
When i put a double space in between (i.e. C\ C\ C\ \C or
&\ &\ &\)it just ignores it.

"Paul" <pz****@rogers.com> wrote in message
news:<L9********************@rogers.com>...
Try using an ampersand instead:

&/ &/ &/ &/ &/ &/ &/ &/

Paul

"Paul" <pc*******@yahoo.com> wrote in message
news:78**************************@posting.google.c om...
> 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 S
> T".
>
> 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".
>
> any ideas would be appreciated. feel free to send me email directly.
> thanks in advance.
>
> Paul

Nov 13 '05 #5

P: n/a
Ok Paul
,
Make sure you are on the Input Mask line and not the Format line.
Copy and paste the exact values from the Input Mask line into this group
replying to this post and I will take a look at it.

Paul

"Paul" <pc*******@yahoo.com> wrote in message
news:78**************************@posting.google.c om...
Thanks for the tip but, I have tried this before but, it didn't work.
I was able to use this by spacing out the record that was already in
the database properly. However when I entered i new recordd it still
didn't spaced it properly. It's only spacing it out properly when i
don't put any spaces in between words (i.e. "THISISANEXAMPLE").

"Paul" <pz****@rogers.com> wrote in message
news:<pO********************@rogers.com>...
Sorry about the slashes.

OK \ means only show the immediate character after the \. SO if you
wanted
2 spaces your could do either:

"(PressSpaceBarTwice)"

or

\(PressSpacebar}\(PressSpacebar)

Both of these would perform the same results
C\ C\ \ C\ \ C

or

C" "C" "C" "C
"Paul" <pc*******@yahoo.com> wrote in message
news:78**************************@posting.google.c om...
> Do you really mean a forward slash (/) as opposed to back slash(\)?
> I tried as you suggested, the slash came out. I tried it with a
> back-slash
> and it's works the same way as C\ C\ C\ C\......Basically, it works
> okay
> without space.
>
> Also, I want to line up the field or entries on a pre-existing form.
> When i put a double space in between (i.e. C\ C\ C\ \C or
> &\ &\ &\)it just ignores it.
>
>
>
> "Paul" <pz****@rogers.com> wrote in message
> news:<L9********************@rogers.com>...
>> Try using an ampersand instead:
>>
>> &/ &/ &/ &/ &/ &/ &/ &/
>>
>> Paul
>>
>> "Paul" <pc*******@yahoo.com> wrote in message
>> news:78**************************@posting.google.c om...
>> > 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 S
>> > T".
>> >
>> > 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".
>> >
>> > any ideas would be appreciated. feel free to send me email directly.
>> > thanks in advance.
>> >
>> > Paul

Nov 13 '05 #6

P: n/a
Thanks for the prompt reply.

Here's the input mask on the report's text box: C" "C" "C" "C"
"C" "C" "C" "C" "C" "C" "C" "C;;_

Test it with "INPUTMASK", "INPUT MASK", "WWWWWW" and
"WWW WW W"

Paul

"Paul" <pz****@rogers.com> wrote in message news:<Xf********************@rogers.com>...
Ok Paul
,
Make sure you are on the Input Mask line and not the Format line.
Copy and paste the exact values from the Input Mask line into this group
replying to this post and I will take a look at it.

Paul

Nov 13 '05 #7

P: n/a
OK Paul,

I tried it out...and it does not work...I dont know why. However, there is
still a simple solution.
Remove the input mask from the controls property.

On the AfterUpdate event of your field add this:
YourControlName.InputMask = "C\ \ \ \ C\ \ \ \ C\ \ \ \ C\ \ \ \ C\ \ \ \ C\
\ \ \ C\ \ \ \ C\ \ \ \ ;0;_"
This particular example uses 4 spaces between each optional character. You
can adjust it to your exact input string....try it out by typing 1 to 8
characters.

Let me know how it works for you.
Paul
"Paul" <pc*******@yahoo.com> wrote in message
news:78*************************@posting.google.co m...
Thanks for the prompt reply.

Here's the input mask on the report's text box: C" "C" "C" "C"
"C" "C" "C" "C" "C" "C" "C" "C;;_

Test it with "INPUTMASK", "INPUT MASK", "WWWWWW" and
"WWW WW W"

Paul

"Paul" <pz****@rogers.com> wrote in message
news:<Xf********************@rogers.com>...
Ok Paul
,
Make sure you are on the Input Mask line and not the Format line.
Copy and paste the exact values from the Input Mask line into this group
replying to this post and I will take a look at it.

Paul

Nov 13 '05 #8

P: n/a
pc*******@yahoo.com (Paul) wrote in
news:78**************************@posting.google.c om:
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 S
T".


I would suggest that you make a function which get a string as input and
inserts spaces.

E.g
Function InsertSpaces(Inputstring As String) As String
Dim i As Integer
Dim Outputstring As String
For i = 1 To Len(Inputstring)
Outputstring = Outputstring + " " + Mid(Inputstring, i, 1)
Next
InsertSpaces = Mid(Outputstring, 2)
End Function

Use the function as control source for the field in the report.

Hope this helps

--
Rolf
Nov 13 '05 #9

P: n/a
Thanks for the reply.

It works on the form but, it doesn't work on the report.

Example: If I specify 4 spaces in between the characters, "TEST" will
display "T E S T" on the form. However, on the
report
it displays "T E S T".

With regards to the number of spaces in between the characters on the
form, it works but, it seems like it still putting a single space on
the report.

With regards to the number of spaces in between words, it works on the
report but, it's only putting a single space.

Example: "TEST ME" on the form will come out as "T E S T M E" on the
report.

Thanks for all your tips. I could probably work on this but, if you
have a better solution, please let me know. Thank you very much. I
appreciate all your help.

Paul

"Paul" <pz****@rogers.com> wrote in message news:<la********************@rogers.com>...
OK Paul,

I tried it out...and it does not work...I dont know why. However, there is
still a simple solution.
Remove the input mask from the controls property.

On the AfterUpdate event of your field add this:
YourControlName.InputMask = "C\ \ \ \ C\ \ \ \ C\ \ \ \ C\ \ \ \ C\ \ \ \ C\
\ \ \ C\ \ \ \ C\ \ \ \ ;0;_"
This particular example uses 4 spaces between each optional character. You
can adjust it to your exact input string....try it out by typing 1 to 8
characters.

Let me know how it works for you.
Paul
"Paul" <pc*******@yahoo.com> wrote in message
news:78*************************@posting.google.co m...
Thanks for the prompt reply.

Here's the input mask on the report's text box: C" "C" "C" "C"
"C" "C" "C" "C" "C" "C" "C" "C;;_

Test it with "INPUTMASK", "INPUT MASK", "WWWWWW" and
"WWW WW W"

Paul

"Paul" <pz****@rogers.com> wrote in message
news:<Xf********************@rogers.com>...
Ok Paul
,
Make sure you are on the Input Mask line and not the Format line.
Copy and paste the exact values from the Input Mask line into this group
replying to this post and I will take a look at it.

Paul

Nov 13 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.