Dan Waters
dwaters at usinternet.com
Mon Jul 21 11:11:48 CDT 2008
Yes - that can be done, but I haven't tried. It looked like one of those things that took a while to learn, but could be really useful. It gives you the ability to have more than 4 formats for one control. I'm 'think' that conditional formatting can be modified in code without going into design mode. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Monday, July 21, 2008 10:49 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Facelift for my App Dan: I just tried the pale yellow conditional formatting when the control has the focus. I like that. But apparently you can't select multiple controls and do them all at once - have to do them one at a time. Do you know if conditional formatting can be done through code - opening the form in design view, scanning the controls for text and combo boxes and setting the conditional formatting? TIA Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Monday, July 21, 2008 8:13 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Facelift for my App Hi Rocky, Suggestions: 1) Use the Flat special effect for all controls - looks more elegant & less tiring on the eyes. Don't use raised boxes. 2) Don't use Times font. Tahoma is good, or try Arial. 3) Use conditional formatting to highlight the control that has the focus. I use a pastel yellow. Don't do this with locked controls. 4) I'd reserve the word 'Exit' for exiting the program completely. i.e., Change 'Exit to Main Menu' to 'Go To Main Menu'. 5) Wherever possible, line up your controls both horizontally and vertically. On Supply Side Maintenance screen, Move the Lead Time control and the Qty. On Hand control to the right to line up the left sides with the controls above. 6) For control borders, try a light gray color. I use 11184810. 7) Tab controls might be helpful for similar tasks. 8) About 30% of my screens are colored - the rest are typical gray. Apply the same colors to common tasks - looks good this way. I've found that only 'pastel' colors are acceptable to look at over time. 9) You display your screenshots using Access 2003 format. The buttons have rounded corners which look a little better. Your organization and layout sure look good! I'll send you a document off-line which shows some of the above. HTH, Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Monday, July 21, 2008 9:30 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Facelift for my App Dear List: This must be my day to ask for help. I want to give one of my apps a facelift - change the colors, fonts, controls - stuff like that - to look more moderne. So I guess I'm looking for some web sties that might have some screen shots of forms from which I could get some ideas. The current app forms can be seen at http://www.e-z-mrp.com/ss_mainmenu.htm. So you can see what I mean - functional but not beautiful. What colors do you all favor for backcolors and forcolors? Fonts? Any suggestions welcome. MTIA, Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com