Change the caption of a field to the field value in order to view full content easily

[June7]

What do you mean by 'cell nor the follow-up table'? Have to code behind a form, not a table. Access has fields, not cells.

[Micron]

What cell? You already have a form showing the text that you want to do this with, yes? On that control I'd use the doube click event. If I'm not mistaken there's no need to lock the control against editing as setting it's source that way will make the record in un-editable, same as if you had an expression in the control. At least I think so.

[Fionfion]

Thank you so much for all your help!! I got it I made a very big text box to show the selected field, and only visible when user clicks on the field. I put the text box on the same form instead of a popup form, as I wanted to keep everything as simple as possible.

Thank you all