Setting Text Box Control Source - Via VBA In Report

[suntsu]

Is there any way that i can change the control source of a text box programatically (within a report)?

an example, a row of 36 single digit text boxes named A1 thru A36, pulling a single character from field [FieldName].

Any help greatly appreciated.

 

[suntsu]

Further information if required:

The underlying query has a calculated field that pulls 6 address lines together, i need each character from this field to appear in a seperate text box in the main report.

(sounds horrible, it's for a pre printed order form being sent out to customers, I have to mimmick the previous blank forms).

Any help with this would be greatly appreciated, I only have 'til the end of the day to complete this

Thanks,

Sun_Tsu

David.Malone@blueyonder.co.uk

 

[suntsu]

Further information if required:

The underlying query has a calculated field that pulls 6 address lines together, i need each character from this field to appear in a seperate text box in the main report.

(sounds horrible, it's for a pre printed order form being sent out to customers, I have to mimmick the previous blank forms).

Any help with this would be greatly appreciated, I only have 'til the end of the day to complete this

Thanks,

Sun_Tsu

David.Malone@blueyonder.co.uk