Hi,
I've got a DW defined with a single column text field visible with a max length of 3k. Only a single row is retrieved. The text field is sized to have only about two dozen lines visible at a time. Vertical Scroll Bar and Auto Vert. Scroll checked. The DWC is sized to just fit the visible column with Vertical Scroll Bar off. While the window (Sheet) has focus, all works as expected. If you have scrolled down the text column (say the bottom of entered text) and click away from the Sheet, the DWC loses focus and the column scroll resets to the top of the field. Set focus back to the sheet, the field scroll returns to the bottom. That should not happen.
Lets "reverse" this... Modify the DW and expand the detail band and the column to hold the expected max text. Turn off scrolling on the column. Modify the DWC and enable Vertical Scroll Bar. Leaving the DWC size the same. I would expect the DWC to scroll from the top of any header to bottom of any footer defined. However, attempting to scroll to view more of the Single row text column does nothing. Click away, the DWC looses focus and *bam* the DWC scrolls to the expected position. Then back again when it regains focus. I've played with cursor position in case that mattered.
These seem to be exact opposite behaviors. Neither of which to me makes sense. Nor seems correct.
Some of the DWC scrolling probably has something to do with returning focus to the column that has focus when the DWC regains focus. But still should be able to scroll to the bottom of the DW.
Explanations? Thoughts? Workarounds?
The desire is to have 2 or more sheets up and be able to work on one while comparing/referencing the other(s). This scrolling issue is making that very difficult.
Thanks
PB19/Windows 7 & 10