We have a three column table, the third column displays a description, most of the time the description fits but occasionally the description is to long for the column. Is there anyway of scrolling this column to view the full description. We have no room to make the column wider so that is not an option.
Any ideas
Tony ..
I do one of the following:
1. Allow for a horizontal scroll bar for the table and then allow the user to resize the column horizontally when needed using the vertical markers at the top of the DB table.
2. Put a double-click on the table and then in column two, pass the text into a dialog box that allows it to see / edit the text there. See the "ZOOM" white paper.
Don Miller
C3 Inc.
Tony,
I think when you scroll an edit table horizontally it will always scroll a whole number of columns. So you mustn't make a column wider than the edit table's client area. Is that what you say? I don't think there's an easy solution.
Possible workaround, but probably not a good one: Use a smaller font for that column or for the whole edit table.
Another dodgy suggestion for a workaround: With some programming divide the text so it runs across several cells, either horizontally or vertically. Probably not a good suggestion.
Possible workaround: Show the data for the current line in full somewhere else.
That somewhere could be an edit box - if you've got room for one in your form. So when the user clicks or tabs to the nth line of the edit table the content of the nth problematic cell is shown in full in the edit box. Btw - I think there's a KB article about this, written by Cameron Purdy.
That somewhere could also be a tooltip (bubble help) text - the kind of text that pops up in a yellow rectangle when the mouse rests above a control. Sprezzatura's got a tooltip extension allowing help for almost any kind of control. For edit tables Sprezz's tooltip shows the content of the current cell. What I don't know is if there are limitations to how much the tooltip text can contain. I can check that tonight if you want to know. I'm going to use Sprezz's tooltip myself - in my new app - perhaps not for edit tables but at least a few other places.
Finally that somewhere could also be a zoom window that shows the content of the current edit table cell / edit line / edit box in full. The user must press a certain key to open the zoom window. (There's something like that in Arev? Don't remember. Anyway - I made one in a previous app of mine.)
Yet another suggestion for a workaround: In some cases it's possible to replace or augment an edit table with a different control. E.g, I have a case where I use an hierarchical list box for display and editing while the real data is in a hidden edit table. (I'm not suggesting you use a list box, though. I assume an edit box is the control of choice for you.) Can involve a bit of programming.
- Oystein -
I show the full contents of each cell on the status line as each cell is clicked. In the poschanged event of the edit table, I put:
ControlName=Get_Property(@Window, "FOCUS")
*Show the current cell's contents in the status line
CurrentPos=Get_Property(ControlName, "SELPOS")
CellContents=Get_Property(ControlName, "CELLPOS", CurrentPos)
If CellContents=" then CellContents= "
* need this to get Send_Info to clear the status line
Call Send_Info(CellContents)
Return 1
Then when, focus goes away from the editable, I clear the status line.
Mark
glicks@compuserve.com
BG-Map Botanical Garden Mapping System [img]http://www.bg-map.com/bgmap.gif[/img]
We have similar problems sometimes which we resolve by using two tables, the second with no row numbers, and placed hard up against the first, so that it looks like one.
The second table can have a horizontal scroll bar and therefore scroll independantly (horizontally) of the first table.
The two tables can have linked vertical scrolling, so that if one scrolls then the other scrolls too.
This looks very smooth, and in fact allows for larger tables too as the variables are split, if 64k is a problem and you cant be bothered to use the INSERT command, and Rowlimit of -1.
If you need code for this please advise Email address.
Colin Rule