Size a textbox

[NISMOJim]

Here's something I've never tried before, but it isn't working...I would like to lengthen the textbox depending on what is in it. Here is the code I'm trying on the On Current property of the form



If Me.CourseD = "Too long to fit" Then
ElseIf Me.CourseD = "Too many letters" Then
ElseIf Me.CourseD = "Just won't fit here" Then
Me.CourseD.Width = 2.6354
Else
Me.CourseD.Width = 2.1875
End If

I've also tried
If Me.CourseD = "Too long to fit" Or
Me.CourseD = "Too many letters" Or
Me.CourseD = "Just won't fit here" Then
Me.CourseD.Width = 2.6354
Else
Me.CourseD.Width = 2.1875
End If
How can I get this to work?

Thanks for any help

[Rod]

The first thought I have is that VBA works in a measure called, 'Twips.' There are 1440 twips to the inch so you are trying to set your width to something arount 1/500 th of an inch!

What on earth are all those string literals?

[NISMOJim]

Definitely not the answer I was expecting about the twips, but it is the one I needed and it is working great now. I was going for inches like is shown in the properties.
As for the strings, they are just an example I came up with when I posted. It was late & I was tired.
Thanks again for your help. I wouldn't have gotten it on my own.

[Rod]

Glad to help. The Access user interface uses the measurement setting you set via the control panel. VBA uses twips and only twips.