Hello,
I am somewhat new to Access and vba, but am trying to complete a request that has been made of me. Access version 2002 WindowsXP.
At this point these text boxes are bound to the table memo field. I have located Stephen Lebans code to limit enter of text field based on characters entered and code to limit text based upon width of a text box (this seems to be most applicable for single line text box). I am have trouble putting everything together.
The objective is: to have a single page report with in which the field size will not shrink or grow and the report page will not shrink or grow to that the specific fields on the report will appear in the same position regardless of amount data entered. The data entry must be restricted at the form level so that the report will appear correctly. The report should also appear as formatted was it was entered in the form (without lines that have wrapped from the line above).
Where I have run into problems is that when I entered text in the form and then ran the report the lines in the report are not wrapping the same as the lines in the form. Both the form and the report are formatted to Verdana 10 pt. and I have played with sizing the width of the field on the form and the report; however, a line in the form which was not wrapping in the form was wrapping in the report field. This could potentially cause the data in the report to be truncated as well messes up the needed format.
In Stephen Leban's database to limit characters the limit is based upon the number entered within the Limit sample form. Is it possible to determine what this number of characters should be through code. The len function will not account for variable character sizes in font.
Is this just too much of a word processing function and I should not expect to be able to do in Access?
I hope that I have explained my dilemma clearly. Any assistance is greatly appreciated.