Search results for query: *

Thanks Missinglinq for the info!

Ed2020, how/where would you use the Ucase() function? Wow! My first 2 stars! Just a few thousand more and I will be up there with Ed202! LOL!

Yes - for example, I have a text box where the data is always four numbers followed by either an "N" or and "E". I always want the "N" or "E" capitalized, so I have the "Format" property in the table design set to "0000L". Now, anyone who enters data into that field is forced to put in four...

I just recently had a problem like this and found out that the problem was in the design of the table you are pulling this field from to put in your combo box. Go to the table where VehicleID is kept and look in the properties for that field. In the "Format" property, check for a ">" symbol...

OK - I just figured out what is going on, so I will post my findings in order to help out anyone who has this porblem in the future. I went to the design of the table that these fields are in and looked at the properties for the fields. The ItemNum was a text field and in the "Format" property...

Yes - column count is 2. Field width is 2.75" with column one = 1" and column two = 1.75" I even tried adding a third and fourth column by selecting the information for ItemNum to be in the 1st and 3rd column and ItemDesc to display in the 2nd and 4th columns. As a result, the 1st and 3rd...

What do you mean by, "do not work"? What are the combo boxes triggering and what specifically is not happening that should be happening on these boxes?

I have a combo box on my form that has two columns. The first shows the item number (ItemNum) and the second column shows the description (ItemDesc). The ItemNum column is the bound field. The problem is that when I click on the drop down arrow, the column with the ItemNum data is not...

afryer, Thanks for the code! The form works smooth as silk now. Many thanks. Jeff

Thanks guys! I know that 26 options is a bit much for an option box, but I know the VBA code to refresh a listbox from the selection made in an option group. I will probably go with the suggestions to use a combo box instead and will just hunt the VBA code down that I need to get the desired...

I am creating an option box so that when a person clicks on one of the options, a list box on the form is populated with info based upon their choice. As I was entering in the names of the choices in the Option Goup Wizard, I was told that I can only have 20 options. As luck would have it, I...