Visual Basic Text Box
Posted by Ampleford on September 10, 2001 8:04 AM
How do I get the text on a VB Text box to drop down a line ? For example to look like this :-
Please Key Week Number
(Week number will default to this week automatically)
And can I get it to recognise "this week" and put that number (from a lookup) onto the text box with the writing. The spread does the work - I just want to tell the user.
Posted by Rob Jackson on September 10, 2001 8:16 AM
You need to enable multiline in the propertys box to get it to do multiline. As far as the week goes you can simply work out the week number by whatever means, I would suggest a simple calculation of how many weeks since a particular date (Latter - Former)/7 as an integer should do it then simply Concatenate in to the text box.
TextBox.value="The week is " & CHR(10) & weeknum
That should do it.
Good luck
Rob
Posted by Rob Jackson on September 10, 2001 8:18 AM
By the way, CHR(10) is equivalent of carriage return or new line.
