Recent content by Mozzie

Oops, sorry, I missed this post. I would need a button per category then I think?

I had looked at ItemsSelected, but it looked like I would need to know the listbox name, which is what I was trying to avoid doing.

Multiple list boxes and one button. I need to use whatever value is selected in the listbox when the button is clicked. This was my way of telling the button which listbox has a selected item. I achieved what is required (an after update that works for every listbox, regardless of name) by...

Hi all, I have several listboxes on an MS Access form in VBA. At the moment, I use a listboxname_AfterUpdate to pass the value of the listbox selection to the tag of a button, so that when the button is clicked the value of current listbox selection is known and can be used within the...

I'm not sure how well a screenshot would illustrate it. On the form design I set a text box (placed below the brief description text box) height to zero and set can grow to yes. No borders. So if there aren't any additional notes, it remains hidden (so there isn't a big gap between each line...

I made an alternative, a text box that is barely visible, but grows when there is content.

The tool tip text has some limitations, such as the delay (which doesn't seem to be possible to change) and a length limit of 255 characters. A possible workaround might be to use VBA to show/hide a text box only for incidents with additional notes. I'll try that now.

I'm using Access 2010, although I can upgrade to whatever the newest version is. Ah, I see, the Control Text Tip has a delay. I wasn't patient enough. Would there be any way (in report view, ideally, or a form) to have a pop-up box or a single box floating to the right to contain this...

Hi all, I have a report that lists incidents for a specific day (reference number, a brief description and a few other fields). There is also an additional notes field, which I would like to be viewable from within the report. For example, as a tooltip when the mouse hovers over the brief...

Hi all, I am modernising our ancient, manual daily reports and decided to use access. I've found quite a few answers on here from reading threads, so I thought I would join, especially with my current "headache". Hopefully I might be able to help others who are stuck, too. Mozzie