splitting text on a report

  • Thread starter Thread starter Lapchien
  • Start date Start date
L

Lapchien

Is it possible to 'spread' the contents of fields accross multiple fields on
a report? So, for example, the word 'horse' - you would have 5 boxes on a
report, one for h, one for o, one for r. one for s, one for e?

I'm thinking you may have to have the word ion all fields and trim the left
and right letters to suit on each one..?

Thanks,
Lap
 
Use the Mid() function in the ControlSource of each text box, e.g.:
=Mid("horse", 1,1)
and then
=Mid("horse", 2,1)
and so on.

Make sure that none of these text boxes have the same Name as your fields.
Access gets confused in the Name is the same as a field, but it it bound to
something else.
 
That works well thanks. However I need the fields to be dynamic, based on
the content of a table...?

Lap
 
You can use it with a field name, e.g.:
=Mid([YourFieldNameHere], 2, 1)

That will get a bit more interesting, as you would have to create a text box
for every possible character in the field.

In more recent versions of Access, you can set the Text Align property of a
text box to Distribute. Might that achieve what you are after?
 
Thanks for your help.


Allen Browne said:
You can use it with a field name, e.g.:
=Mid([YourFieldNameHere], 2, 1)

That will get a bit more interesting, as you would have to create a text
box
for every possible character in the field.

In more recent versions of Access, you can set the Text Align property of
a
text box to Distribute. Might that achieve what you are after?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Lapchien said:
That works well thanks. However I need the fields to be dynamic, based
on
the content of a table...?

Lap
Click to expand...
Click to expand...
 
Back
Top