On Thu, 2005-11-10 at 00:15 +1100, Kelvin Eldridge wrote: > Hi Jonathon, > > By changing, I mean changing the text which appears in the column heading. > This does not appear to be what you meant.
No, that is not what I meant. > If I now understand, you mean the style of the heading or the style on a > column by column basis. This cannot be done in MS Access (at least to my > knowledge). Correct. My friend said there was a simple method similar to conditional formatting, but it was so faulty that they refuse to use it. > In the case of multi-column combo boxes different styles for headings and > even perhaps individual columns is something worth suggesting. More > important columns could then be emphasised. Exactly! > Is that the type of thing you were thinking? Always worth adding to > Issuezilla so the ideas can be considered. > > In terms of using the table control versus the multi-column combo box I'm > not quite certain what you are asking. Sorry if I miss the point in the > following explanation. That's okay, I am trying to work out the differences here myself. > A table control is generally used to present records (from a table) and > enables the user to edit the data in the records. Just like using the > Explorer for data sources but within a form. Agreed. > A single column combo box is used to return a single value which is then > stored in the underlying table. A multi-column combo box the extra columns > simply provides more information to the user. For example: a single column > combo box may display an employee number which can be selected. A > multi-column combo box could display the employee number, first name, last > name. When a row is selected the single value of employee number is still > returned. The other columns simply provided additional information to assist > the user. OK. However, I presumed that you would get a value back from a table as well, which is not the case. It can however, be simulated after a fashion by combination of a single list and table control. The single list is linked to the employee number based on your example, and the table control shows whatever columns you want. > Thus the table control and combo box (multi or single column) have two > different roles. The table control displays records. The combo box (single > or multi-column) is used for selecting a record and returning a value. Agreed, but I would not consider this "urgent" development work. Maybe it would be simpler to just offer a return value on the table control? > As I said, hopefully I haven't missed the point of your question. Sorry if I > have. No, you got the point :) Regards Jonathon -- OOo Tips: http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase: http://mindmeld.cybersite.com.au Training4Linux: http://www.training4linux.com Cybersite Consulting: http://www.cybersite.com.au --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
