|
||||||
Access MVP (2010-2015) |
You want to use TEXT as the Control Source of a Control on your Form but you keep getting an error OR it doesn’t show as expected because your text contains an apostrophe or quotation mark(s). For help see chart below… Control Source Property Result Explanation =”This is literal text.” This is literal text. Literal […] 558 total views When you have a Log On Form you can indicate what is to be entered by using the Format Property of the Control. By doing it this way the only value stored in the Table is what is entered, Enter Password is only for display. In the Format Property of the Text or Memo field: […] 543 total views There are many examples of how to handle new entries to Combo Boxes, a.k.a. Not_In_List events. However, the one that is not so easily found is how to handle entries that include more than just what’s in the Combo Box. For example, you’re entering an Order from a new Client and you need more than […] 846 total views I sometimes use Combo Boxes as *labels*. This comes in especially handy in the communications section of the Contacts Form where any given Contact can have more than one eMail or more than one phone. To move the drop down to the left… while the Form is in Design Mode click on the Combo Box. […] 678 total views Normally, it’s not an issue if an End User tries to type in more characters than the Control will allow… they just can’t type anymore. BUT, if you are using an UNBOUND Form for data entry this is a big problem, they will not be able to Save and with a not so nice message. […] 1,283 total views This tip is for Access 2007 and up… Select all the Controls you want to keep together by holding down the Ctrl key on your keyboard while selecting On the Arrange tab on the Ribbon, select Size/Space then Grouping and click Group/Ungroup 19,148 total views, 1 views today 19,148 total views, 1 views today When you open a Form, the first field (Control) in your preset Tab Stop is always highlighted. This has been known to cause issues… Users press the Enter key, thereby eliminating the data that was present (and don’t always remember to press Undo). Users begin typing not realizing they are not on a new […] 6,641 total views |
Have an Access... ential you want to share? Drop me a line!
Note, all tips are moderated before posting. |
||||
|
Copyright © 2024 Access… entials - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
