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

[Fionfion]

May I know whether it is possible to change the caption of a field to the field value, as sometimes the field content is too long and cannot fully shown?

Thanks!!!!

[June7]

Could but the label caption would be the same for all records. And how would that help to display full value - if the textbox is not wide enough how could the label be? What type of data - number or text? Is form in Single, Continuous, or Datasheet view?

[Micron]

People use the word field when they should be saying control. Since you didn't say table field nor query field your meaning isn't clear. You could even be referring to a form label.

[Fionfion]

I do apologize for the confusion, let me rephrase that:

I have a table (datasheet) with a field called "remarks", and sometimes the remark can be really long and cannot show full content. In Excel we can just increase one row height and that's it - But in Access I cannot just increase one row height.

So I am thinking whether it is possible if I can just hover over the cell (not sure what it's called in Access), and the whole content will appear. (is it called control tip?)

Thanks!!

[Micron]

A table is one thing, a data sheet is a type of form view IMO. The former has no tip feature AFAIK. The latter does because it's a control. I find the tip feature to be temperamental. More info about what you have and need might help. The best method of viewing large blocks of text is often a report but that provides no means of editing. Sometimes a pop up form with one text box to hold the contents of one control from a "parent" form works well as it can provide the ability to edit whereas the parent form could be locked.

[CJ_London]

Or use standard functionality of shift-F2 to open the zoombox - works for forms and datasheets

[Micron]

True, but it's not customizable AFAIK, beyond formatting the text display (which I'm not sure I see as an advantage).
First, all text is selected when invoked and a single keystroke could wipe out the data if the user wasn't astute enough to click cancel or even escape the record edit.
Users also have to know to Ctrl+Enter to start a new line, and if they don't do so, it behaves oddly. Plus it can't be locked if you want to prevent editing and only provide an expanded view. But kudos to you for thinking of it!

[CJ_London]

never said the zoom box is better than sliced bread Really depends on how much of an issue it really is. If viewing in datasheet, you could just widen the column rather than increase row height

[Fionfion]

Zoom box will work but I'm trying to make it more user-friendly, as no one in my office knows more about Access than me (and I'm a beginner)

So my database looks like this:

Customer's record in a form (single form so one customer in a page)

with a subform for all the follow-up details with that customer (linked to a table), which contains the follow-up date & time, and the follow-up details (the "remarks" field I was talking about)

Any idea please?

A table is one thing, a data sheet is a type of form view IMO. The former has no tip feature AFAIK. The latter does because it's a control. I find the tip feature to be temperamental. More info about what you have and need might help. The best method of viewing large blocks of text is often a report but that provides no means of editing. Sometimes a pop up form with one text box to hold the contents of one control from a "parent" form works well as it can provide the ability to edit whereas the parent form could be locked.

Will Pop up form work for this case?

[June7]

Yes, could use a popup form that opens to specific record with a huge textbox bound to the remarks field. However, if that record is in edit mode on the subform could not do edits in the popup.

Or build the subform as Continuous view and arrange and size controls.

[Micron]

I would consider making the form modal as well lest you end up with a zoom form that is out of sync with the form that calls it.

[Fionfion]

Is that possible if I click on the remark cell, a popup form will appear with the content of that cell? Let's say if the follow-up table in my customer form looks like following:

Date Time Follow-up remark
1-Nov 18:00 Called and left a voice mail

If I click on the cell (Called and left a voice mail), and a popup form will appear with a textbox that says "Called and left a voice mail", can this be done?

[Micron]

That question was answered affirmatively in posts 5, 10 and 11.

[Fionfion]

That question was answered affirmatively in posts 5, 10 and 11.

Can you please briefly explain how to do that? I was thinking if I need to click on the cell to open the popup, I suppose I will need to add the code in "On click" event right? But I cannot find "on click" under event of the cell nor the follow-up table.

[Bulzie]

Create the new form with one large unbound control called ResponseText. In OnOpen event of this form, put Me.ResponseText = Forms![YourMainForm]![YourSubForm]![Response] so that whatever was in that response field is now showing in this pop up form. Lock the field on pop up form so value cannot be edited.

Another option might be to create a 2nd Response field but that is bigger and make it invisible. Then use Mouseover or if they click in that response field, make it visible: Me.Response2.visible = True. Few different ways to do it as others suggested, just try them out and see what works best.