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 9 2921
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
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
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
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
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
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
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 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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Miranda Evans |
last post by:
In my application, a text box control resides in a form. The text box
control is unbound, but--assuming all edits are passed when the user
click a command button on the form--the contents of the...
|
by: johnp |
last post by:
Hi,
Our Tech department updated users to Office 2003 this week. Now the
input mask in one of the applications is showing up as:
(###) ###-###
The input mask wizard works correctly when I...
|
by: AA Arens |
last post by:
When I want the first character of a field to be Uppercased, I need to
make an input mask, like >L< followed by ??????? for example. But this
mask creates ____ in an unfilled field, which I don't...
|
by: bobh |
last post by:
Hi All,
Been trying to get a typed entry to display as I neeed it to and can't
get it to work. I've been playing around with field datatype and input
mask but no luck so, maybe you can help
...
|
by: sparks |
last post by:
Can you do this.
We have some fields with double set and an input mask of
fixed
decimal place 2
input mask ###.##
works great..
|
by: ilogboy |
last post by:
Below is a copy of my Hangman project... I am missing a couple more functions and I don't know how to enhance it... Here are the things I want it to do: 1) I want it to determine the scores for...
|
by: =?Utf-8?B?QWw=?= |
last post by:
I am working in vb2005. how can I calculate business days (not including
holidays and weekends) between 2 dates? thanks
Al
|
by: Nezhate |
last post by:
Hi There,
I'm writing a program that takes a decimal number and returns it's
binary equivalent.
the problem is that I don't know how to return (from function) the
binary value as an array of...
|
by: milov |
last post by:
Project to do simulation testing (me teacher). Page one writes in real time to page two...both displayed at sam time with frames. Code below. Problem...I want to keep score. Each choice needs a...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |