BorderStyle Property

Question

I have a form with a text box on it.  I want to use code to change the BorderStyle propery depending on some things.

I tried 'Me.LotNumber.BorderStyle = "Solid"', but that gives a data type mismatch.  Can anyone steer me in the right direction?

Answer 1

BorderStyle is a numeric property. Possible values are 0 (Transparent), 1 (Solid), …, 8 (Double Solid). See https://docs.microsoft.com/en-us/office/vba/api/Access.TextBox.BorderStyle

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 2

Never mind, sorry to have bothered you. 

Me.LotNumber.BorderStyle = 0 is transparent

Me.LotNumber.BorderStyle = 1 is solid.

Answer 3

Thanks Hans.