My-Yen said:
Sorry, I am not clear where I could input the codes to
(format event). I am a beginner. I have textboxes that
either contains the control source (fieldname) or starts
with the =trim statement.
You can get to the Format event procedure by clicking on a
blank area of the section containing the text box / label
that you want to make visible or not. Then look at the
section's Propert Sheet (View menu) look around the property
list and click on the Format property. Then select [Event
Procedure] in the properties drop down list (on right side
of the property. Next, clicking on the ... button at the
far right of the property should take you to the section's
Format event procedure where you can add te code.
--
Marsh
MVP [MS Access]
