Recent content by CindyKredo

AND... just learned something new that is valuable with that @ format which I can use - but now knowing that it also apparently strips other formatting properties. Totally getting off topic here now, but it seems like it's only useful when we want to substitute text for a null or zero string...

OMG Vlad - found the cause. The string field on the linked table had a format property of @. I don't recall ever setting that - as a general rule I do all formatting at the form level. When I saved the linked table as a local table, it stripped the format property - hence the local table was...

I created another database that has nothing other than the underlying table and one form with a list box that is using that table (lt_categories). Problem persists. The table is a linked table. I opened the linked table - saved it in design view to a local table, and pasted the same records...

oh wow. New database. Did not bring in problem form. Created a new form and only put ONE list box on it, which is using the same Row Source. There are only two fields in the source. I changed the forecolor to red just for giggles. Then when I go to form view, the primary key appears in...

Sounded like it would be worth a try - but even with a totally new database, the issue remains. However, I copied and pasted the form objects - and maybe just maybe it will be better to not use anything from the old form - to actually build the problem form totally from scratch? I'm going to...

Vlad - you missed part of the thread. I originally reported this as a coding issue, but it turns out it has nothing to do with the code. As a matter of fact, with all code STRIPPED from the form (recreated), the problem is still there. Picture a form that has a handful of list boxes on it...

Just did that. Still have same issue. Thanks for the suggestion, I had hope it would work. :unsure:

Minty - a new name didn't change anything. I did laugh though - because over lunch I was explaining this to my husband, and said the ONLY thing I can possibly think is that lstContactTypes has some internal meaning to access.... but lstIndivContTypes as a new name didn't help. :( I'm done...

So weird. That didn't work either. The fear of course is that there is some sort of corruption somewhere - but I deleted the list box, then did a compact and repair. Then did a command box full decompile (/decompile switch). Then compacted and repaired. Then recreated the list box, did...

Yes - good suggestion for something I have seen in the past. I already did that, but will try a total decompile with the decompile command.

Yes - I'm being picky - the visual "grey" isn't super obvious to the user that the list box is no longer active. I wanted it to stand out after they pick a report when one of the filter option list boxes doesn't apply. The control doesn't have the focus - but I also just discovered something...

I have a list of reports on a form (in a list box). When the user selects an item in this listbox, after update event code on the list of reports enables or disables four other list boxes on the form. This same code chunk changes the font in a disabled list box to be grey. Well - it is...

Gale - in the future when you import data from Excel, I've found the best way to control exactly what gets imported is to assign a named range to the cells you are importing. You can do that by selecting all of the cells that will be imported (don't include empty rows below or empty columns to...

Given that Microsoft is now defaulting installations to 64 bit, I'm revamping some 32 bit code to work in either 32 or 64 bit installations. I vaguely recall once reading that users should all be on the same platform - does anyone know if this is the case? As long as each user has their own...

Sure enough - the new version of the database used the asterisk wildcard in one of the base queries, which wasn't needed in the old version. Thank you pbaldy, and thanks dBguy for the outreach!