Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form Display Problem

Status
Not open for further replies.

jcl5

IS-IT--Management
Dec 6, 2002
89
0
0
GB
Using oracle 8i and Crystal 9

I have a report that replicates a paper form which users complete manually. The idea is that this report will display data already held in the database and when printed users will complete missing or incorrect data.

The form has the field names in boxes with each character going into a separate box but I cannot replicate this exactly in Crystal. Nearest I have got is to draw boxes on the report and format the field to 'Character Spacing Exactly' = 14 and placing on top of the boxes. It doesn't work exactly so was wondering if there was an easy way to do this.

Can I format the field to put formatting around each character?

Any help greatly appreciated.

Many thanks

jcl5
 
Not sure if I have understood you but you could try using formulae and break field up.

If string try creating as many formula as you have characters.
@char1
Left(fieldname,1)
@char2
Mid(fieldname, 2, 1)
etc

YOu can then place and format as you wish.

Ian



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top