Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Border Style Property

Status
Not open for further replies.
jojones

jojones

Programmer
Dec 4, 2000
104
AU
How can I change the BorderStyle of a Form when in Form View? When I try

Me.BorderStyle = 1
I get a "You can't assign a value to this object" error

and when I try

Me.BorderStyle.Value = 1
I get an "Invalid Qualifier" error on BorderStyle.

Not sure what to do. Please help. Thanks
Jo :) Cheers
Jo Jones
 
Sort by date Sort by votes
Hi jojones,
Sorry to say, but you can't. From the Access 97 VBA helpfile on the BorderStyle property:
"You can set the BorderStyle property for a form only in form Design view by using the form's property sheet, a macro, or Visual Basic."

Sorry.. :-( Katie
Hi! I'm currently studying the COM+ programming model. Hopefully YOU'RE having fun, which would make one of us..
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Aximboy
  • Locked
  • Question
Change SQL property of saved query 2
Replies
5
Views
96
kjv1611
kjv1611
patriciaxxx
  • Locked
  • Question
Compile error Invalid use of property and Runtime Error 13 Type Mismatch
Replies
4
Views
185
strongm
strongm
JulianAustin
  • Locked
  • Question
Compile Error Expecting Sub, Function or Property
Replies
8
Views
172
JulianAustin
JulianAustin
2009luca
  • Locked
  • Question
COPY TABLE1 TO TABLE2 with index, property, ecc... 1
Replies
2
Views
78
2009luca
2009luca
vba317
  • Locked
  • Question
RunTime error 1004 Unable to get PivotFields property of the pivot table class 2
Replies
7
Views
139
vba317
vba317

Part and Inventory Search

Sponsor

Back
Top