How to improve the visuals of Access applications

I'm interested in what limitations you have experienced in trying to make your Access application look more modern. What are the limitations of Access forms and reports that keep you from creating applications that look like Web 2.0 apps? Some of the things I was thinking about include:

• MouseIn and MouseOut events
• The ability to control style colors of hyperlinks
• The color of the selected item in list and combo boxes
• Easier way to build dropdown menus in forms

It isn't clear how much of this list would actually make it into the product--I would just like to compile a great pick list for the planning process.

Thoughts?

Comments

• Anonymous
  March 22, 2007
  Clint, it's very easy to implement dropdown menus in Forms with shortcut menus (that Access 2007 doesn't support, sic!) : http://www.alessandrobaraldi.it/DettaglioFaq.asp?IdFAQ=77

Forms limitation:

• Conditional Formatting limited to 3 conditions, too slow, not enough flexible in the formatting options.
• We can creat new controls at Design Time but not a Runtime with VBA.
• Access doesn't support native TreeView and ListView controls
• Access doesn't support SubForms in Continuous forms (only in DataSheets Forms, and this is much strange)
• Formatting/Layout options of Comboxes/ListBoxes are very limited (and the limit of the 65536 records is anachronistic)
•  We cannot insert buttons in DataSheet view. Reports limitation:
• It's impossible to insert boxes or other vectorial objects (only lines and rectangles) with standard ToolBox For the rest, Access Report Engine is very powerful... Bye

• Anonymous
  March 22, 2007
  I wrote 2 articles for Smart Access on this very subject:

1.  Giving your Access Form Controls Web-Style Behaviours Smart Access, October 2003 Issue
2.  Breadcrumbs, or How I learnt to Love the Switchboard Smart Access, September 2005 Issue The code in the October 2003 article works very well and I use it in all apps to give them a modern feel (web paradigm, etc, etc).  A 'style sheet' However, it is all based on the mousemove event, so mouse in and mouse out events would be good. The 2005 article shows how to give a switchboard a clickable breadcrumb, that allows the user to click their way out of nested switchboard menus.  I didn't have the time to fully optimise the code, so it is a bit convoluted. In both cases, the classes can be dumped in a reusable library file, but each form still needs to deal with initialization and termination, so there is extra baggage.  However, for the price of one, by handling different events, the same classes allow highlighting of input controls, expanding of text boxes to display all the text it holds, as well a fully customisable 'tab control' that allows you to choose colours other than Stalin Grey, so there is some payback. But the point of all this is:  You have to go to a lot of trouble to get UI behaviours in Access apps that users brought up on the web nowadays take for granted. I will look up the link for drop down menus (fortunately, I understand written Italian!), but...  aren't we supposed to use the ribbon now? With larger and larger screen sizes, forms that just adapt to the screen size would be good.  Yes, I know you can use APIs, but 'Tom' doesn't.  You also need to be good at arithmetic to get a plethora of controls to do what you want.  Poor Tom is strugglling to think relationally, and he also has to know what 2 plus 2 is. Outlook style side bars would be good.  Why not?  We're worth it! Wouldn't it be better to put .NET into Access and be done with it?  I write a lot of classes to control the interface, so a constructor would be nice.  What about some XAML?  OK, OK, Father Christmas doesn't exist.

• Anonymous
  March 22, 2007
  Hi Clint: Any updates on the Access Runtime? My apps are ready to deploy subject to testing in the runtime. Thanks

• Anonymous
  March 22, 2007
  Andrew, Interesting--I will send you follow up email. We did enable forms to adapt to screen size with the new anchoring in Access 2007. Manfred, Thanks for your feedback. Rick, The runtime is coming along. The target date right now is June. We are making sure it has the right features and as bug free as possible.

• Anonymous
  March 22, 2007
  It'd be nice to have a method of controlling the styles across the forms and reports within an application. Something like style sheets or themes in ASP.NET would make it very simple to maintain a consistent look and feel.

• Anonymous
  March 22, 2007
  Clint, The non-availability of the runtime before the "target date" of June is not good.  http://msdn2.microsoft.com/en-us/office/bb229700.aspx said, and still says, "Shortly after the release to the general public of Microsoft Office Access 2007 (January 2007), Microsoft will make available the Access 2007 Developer Extensions and the Access 2007 Runtime." Some people have been using Access 2007 trial version on that understanding that "shortly" actually meant "shortly" and are now going to have their trial version expire before the runtime is ready. Do you know whether uninstalling the trial version and the reinstalling it allows the user to continue to use it, please? If not, there are going to be some unhappy people around.

• Anonymous
  March 22, 2007
  (I do not use 2007, if that already does these things, I appologise) Buttons and ckeckboxes should have background colors Checkboxes should be resizable I have some code which allows a form to have several layouts, the users screen resolution determines which layout is displayed. I think this should be built into Access Transparrent images should be supported (instead of the workarounds now required)

• Anonymous
  March 22, 2007
  I can't believe that it's 2007 and Access still doesn't have a TreeView or ListView, or indeed any additional controls.  Was adding more controls and form functionality considered at any point for 2007? There are still so many things one could easily do even with VB6 which are very difficult in Access to do without clunky workarounds.

• Anonymous
  March 22, 2007
  Clint, further to Andrew's comments re: putting .NET into Access, is it conceivable that some future version of Access (maybe 15!) could actually be build with .NET?

• Anonymous
  March 23, 2007
  Hi Clint,

• more control properties e.g. shadows, round edges, transparency (fading)...
• more control display flexibilities e.g. layers (not just bring to front/send to back)
• more object properties e.g. controlling the Scrollbar colors, title bar, borders (color, size/strength, rounded), navigation buttons/record selector customization
• maybe application specific properties e.g. scrollbars, status bar, task bar, ribbon, window frame...colors/effects
• internal fonts capability so you can develop with a font you have on your machine and deploy it to anyone without worries
• better tab control customization
• build in gradient color support (e.g. object backgrounds)
• not sure if this is in 2007 (I heard Jeff mention something)...an easy method of creating and managing internal templates for forms/reports (maybe a wizard ;) which is portable to other applications...something similar to CSS
• combobox/listbox different row and column colors and checkboxes or images as values

• Anonymous
  March 23, 2007
  Easier application background color/image alteration. (Not just forms and reports.) Rounded corners on controls would be a delightful if not sightful improvement! Especially command buttons, toggle buttons & tabs controls. Easier use/employment of AVI, MPG, animated Gifs and such (as form enhancements) would be a treat. And how about sizeable checkboxes & radio buttons? OK, there' my 2¢ worth . . .

• Anonymous
  March 23, 2007
  I have found with a little creativity you can make Access forms look relevant and compelling. Couple things that would be nice:

• collapsible elements that move the page content for errors (Go to http://www.projectbreakout.com/users/new and click signup without entering data or goto http://sutori.com and click the "what does this mean?" text beside the striking a nerve heading.

• Better button customization so you still get all the click actions of a button without the grey look.

• Better TAB customization so you could make your tabs look modern.

• Anonymous
  March 23, 2007
  The comment has been removed

• Anonymous
  March 23, 2007
  The comment has been removed

• Anonymous
  March 23, 2007
  I'd like to see the ability to display pictures in data sheets -- so that I can add my own health indicator type graphics. Conditional Formatting Rules -- could the Excel 2007 options and rules be added? Can something be done about the performance of conditional formatting rules?  Currently you see the data sheet of data except for the conditional formatting rules, then then you see it slowly fill in the rules for each record, the whole table "blinks", etc. Give us the ability to have "disabled" formatting of cells in a data sheet, but still let them be selectable.  Right now you have to do Locked = True, Disabled = False -- but then there's no visual cue to the user that they can't edit the cell contents -- I want to be able to make those cells have a Grey or "disabled" looking font like if you set the cell to be disabled, but I want the user to be able to click in the cell so they can use the right-click filter sorts, select and copy data, etc.  Currently the only work around is to add a conditional formatting rule like "1=1" and then set the formatting to grey, but then you end up taking a major performance hit.

• Anonymous
  March 23, 2007
  I second the limited formatting options of Listboxes. As for the ribbon: The lack of an assistent/editor for custom ribbons is a drawback. Also I would welcome the support of popup menus without having to code them in VBA. (Perhaps an extension to the ribbon, as the popups in pre-2007 was a variation of commandbars?)

• Anonymous
  March 25, 2007
  I agree with almost all the previous suggestions.  I would add the ability to select the highlight color and selection rectangle color for the active row and cell in a datasheet view. Also, I would provide the option to use and advanced VS2005-like commandbar object instead of the ribbons.  Ribbons would be a lot nicer if we could reduce the huge size of the contents, specify custom bitmaps, add custom controls, etc. Also, we need a trivial easy way to program task bars, in the same way an Access form is created.  And I would allow multiple dockable taskbars (Navigation panes) like VS 2005.

• Anonymous
  March 25, 2007
  The comment has been removed

• Anonymous
  March 26, 2007
  The comment has been removed

• Anonymous
  March 26, 2007
  Regarding Label controls, it would be nice if they had a Tab Stop property so that they would be accessible via the keyboard.

• Anonymous
  March 26, 2007
  AL/Jeff, Can you guys send me pictures of the behavior in Access 2002 and how it changed in 2003? The developer in the area knows of the limitations but we are unaware of how it might have changed from previous versions. Pictures might help us get a better understanding of what is going on. Jeff, Can you send me exact repro steps for the [...] bug? I'm not able to repro it. Also, if you want to send me repros of mouse move and image flicker bugs I can see what can be done in Access 2007 SP1. We are looking at a flicker issue and it would be great if maybe the fix can address this issue as well. MouseMove problably doesn't get as much testing as it should because the event model isn't very easy to use. If we did MouseIn and MouseOut it would make it far easier for people to implement visual transitions.

• Anonymous
  March 28, 2007
  When is  Access 2007 SP1 due out? Will the right click menus in sub forms be fixed in SP1? This is an important feature for an Access app thatI am migrating to A07. Will DAO replication be fixed in SP1? See this UA thread http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1328008&page=&view=&sb=5&o=&fpart=all&vc=1