JohnHarkins
MIS
I've searched high and low and I know there's an easy answer, but it's eluding me.
I have a wide continuous form with lots of fields and want to create an "editing window" that will reflect two things: the name of the field that the cursor's positioned at on whatever row is current and the value of that field. Why? Well, the client wants to have a spreadsheet-like continuous form that contains updateable fields. Only problem is that the "spreadsheet" is so wide that the a number of the fields have to be narrowed to the point that seeing the whole value is possible only with one of the following techniques:
1. Using shift-F2 to open a separate window that can be edited,
2. Deepening the fields so that with text wraps around onto additional lines, or
3. Creating an "editing window" a la Excel that contains a "synchronized value" with the contents of the current field on the current row of the continuous form (the editing window resides in the header portion of the continuous form).
So, the object is to create a window whose value is tied to the field where the cursor resides at any given time in the continuous form and to show the name of that field (kind of like giving the row/column coordinates or name of the selected field in Excel).
I also have to handle the case where I don't want the editing window to show any value when the cursor field is, for example, a check-box instead of a text box.
How do I reference the name of the current field? Ideally, the current field would contain the name of the heading value above the detail data in the continuous form. (I never am quite sure where I start looking in Access’ help for things like these attributes of a field and the proper way to reference them. Ugh!)
Thanks,
John
John Harkins
I have a wide continuous form with lots of fields and want to create an "editing window" that will reflect two things: the name of the field that the cursor's positioned at on whatever row is current and the value of that field. Why? Well, the client wants to have a spreadsheet-like continuous form that contains updateable fields. Only problem is that the "spreadsheet" is so wide that the a number of the fields have to be narrowed to the point that seeing the whole value is possible only with one of the following techniques:
1. Using shift-F2 to open a separate window that can be edited,
2. Deepening the fields so that with text wraps around onto additional lines, or
3. Creating an "editing window" a la Excel that contains a "synchronized value" with the contents of the current field on the current row of the continuous form (the editing window resides in the header portion of the continuous form).
So, the object is to create a window whose value is tied to the field where the cursor resides at any given time in the continuous form and to show the name of that field (kind of like giving the row/column coordinates or name of the selected field in Excel).
I also have to handle the case where I don't want the editing window to show any value when the cursor field is, for example, a check-box instead of a text box.
How do I reference the name of the current field? Ideally, the current field would contain the name of the heading value above the detail data in the continuous form. (I never am quite sure where I start looking in Access’ help for things like these attributes of a field and the proper way to reference them. Ugh!)
Thanks,
John
John Harkins