This is being done on a report? The easiest might be to
- hide the fname and lname controls (textboxes on report that hold first and last names),
- create a new textbox and remove its label,
- center it under the picture control
- make its control source = 1stInvisibleTextbox & " " & 2ndInvisibleTextbox
- and while still in design view on the report, go to the property sheet and set the control text alignment property to be centered.
As long as the picture will always be centered in its control, all should be fine.
Also possible to concatenate the field names into one textbox and eliminate the other two, but I'm considering the comment re experience when making the above suggestion.
Or would the format event be necessary because this is a multi line sheet of labels?
Last edited by Micron; 09-17-2018 at 08:36 AM.
Reason: added questions
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.