Need an application for filling in forms containging boxex for each letter.

[momog]

Hello everybody,

I am developing an application which should allow to fill in bank forms. My problem is that these forms contain boxex for each letter, and I don't know how to print every letter exactly in the box.

For example the name
"ROMOLO SALAS" should be printed
"R O M O L O S A L A S". (each letter in a box)

I am printing the information on "Reports".

One solution was to put as much number of text boxex on the report as the boxex on the form, and then parse the String and put every letter in the corresponding textbox. But the "value" property for the "Repoerts does not exist".

Do anybody has any idea ??

 

[Steve R.]

Hello everybody,

I am developing an application which should allow to fill in bank forms. My problem is that these forms contain boxex for each letter, and I don't know how to print every letter exactly in the box.

For example the name
"ROMOLO SALAS" should be printed
"R O M O L O S A L A S". (each letter in a box)

I am printing the information on "Reports".

One solution was to put as much number of text boxex on the report as the boxex on the form, and then parse the String and put every letter in the corresponding textbox. But the "value" property for the "Repoerts does not exist".

Do anybody has any idea ??

It appears that you are potentially asking two questions.

Is your question how to fill in a form where each letter is in its own textbox?

AND/OR

Is your question how to print to a report that displays each letter in a textbox?

If you are printing to a pre-defined standard report, the solution would be to create a text box for each letter. Use the textbox border property to create a black or other color border. Use the MID function to select the letter that goes into each textbox of the report. (You will need to use the LEN function to get the length of each string.)

 

[CarolW]

Hi Momog,
Have you tried to use concatenation .... works for me.http://www.techonthenet.com/access/functions/string/concat.php

CarolW

 

[momog]

Thanks CarolW and Steve R for your answers,

Actually english is not my mother tongue so some times I have difficulty to express myself.

My question was : How can I flill in the textboxes which are on a pre-defined Report.

for exapmle when I need to fill any text box in a form, I write the following code : me.textbox.value = "Hello World". or Form_myform.txtbox.value="Hello World"

but for a report following code does not work:

Report_myreport.txtbox.value = "Hello World"

Thanks for your help please

 

[Steve R.]

If you are printing to a pre-defined standard report, the solution would be to create a text box for each letter. Use the textbox border property to create a black or other color border. Use the MID function to select the letter that goes into each textbox of the report. (You will need to use the LEN function to get the length of each string.)

My question was : How can I flill in the textboxes which are on a pre-defined Report.

Since you have a pre-defined report, you will need a text box for each letter on the REPORT. Textbox01, Textbox02, Textbox03, etc.

Now to "strip" the correct letter from "me.textbox" into the correct box on the Report, use the MID function. Thus for textbox01:

Textbox01=MID(me.Textbox,1,1)

For Textbox02:

Textbox02=MID(me.Textbox,2,1)

And so on. This is the simple brute force solution. The more elegant approach would be to use a function.

Other issues:
* You will need to transfer the value of me.textbox to the report with OpenArgs.
* Also, you will need to select a border width and color for you report textboxes so that they appear as little boxes.