Recent content by LanaR

@June7 Yes; I'm starting to agree. It was just something that I thought might be quite simple to implement. But it's starting to look as if the juice isn't worth the squeeze.

Better than that, here's a copy of the DB

I'm currently playing with some code to deal with plurals in a combo box. So depending on a text box that accepts a numeric value, the combo will show either singular or plural depending on the value in the text box. The code is If Me.Quantity.Value > 1 Then Me.Combo0.ColumnWidths...

Is there an event or a way to detect when a form's native filter button is clicked?

My bad :(

Storing the number as short text and adding the leading zero back on, does the trick. However, I'm still interested on an academic level whether or not this can be achieved using code :unsure:

Thanks that code is a whole lot simpler (y) In answer to your questions; Me.Text21 = Combo11.Column(2) 01234 stored appears as 1234 Single form

Because Access will drop off the leading zero in numeric fields. I'm going to try storing the codes as Short Text which should fix the problem

Yep, the table is formatted to store leading zeros. Yes, the variables are picking up the values I'm expecting

I'm populating an unbound text box from a column in a combo box. This combo is selecting a suburb from a rowsource dependent on the country of origin. For each country, the post code is a fixed numeric length. Each of the tables is formatted to show the leading zero, and this displays just fine...

Well it was AUD 19.99, they had a "Sale" on ;)

Just the one payment (y) It also says full lifetime access

@Pat Hartman possibly, it's been almost two years since I signed up for that course. TBH I was a little surprised when I logged back in and found that I could still access the course material.

Not that I'm aware of

@Pat Hartman , I've just checked, and I still have access to the Udemy course. Also, there are a bunch of PDFs for each unit which you can download for future reference.