Answered by:
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?
Sunday, September 23, 2018 9:02 PM
Answers
-
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)
- Marked as answer by tkosel Sunday, September 23, 2018 9:15 PM
Sunday, September 23, 2018 9:09 PM -
Never mind, sorry to have bothered you.
Me.LotNumber.BorderStyle = 0 is transparent
Me.LotNumber.BorderStyle = 1 is solid.
- Marked as answer by tkosel Sunday, September 23, 2018 9:13 PM
Sunday, September 23, 2018 9:13 PM
All replies
-
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)
- Marked as answer by tkosel Sunday, September 23, 2018 9:15 PM
Sunday, September 23, 2018 9:09 PM -
Never mind, sorry to have bothered you.
Me.LotNumber.BorderStyle = 0 is transparent
Me.LotNumber.BorderStyle = 1 is solid.
- Marked as answer by tkosel Sunday, September 23, 2018 9:13 PM
Sunday, September 23, 2018 9:13 PM -
Thanks Hans.
Sunday, September 23, 2018 9:16 PM