Printable View
1. How do I position text in a text box at run time??
2. I am populating a text box at runtime from a database, but each record does not appear in a new line. the records appear wrapped up. If I use vbcr for a new line, it comes as a "|" but no new line. the multiline property is set to true. How do I insert a new line?? Pleae help me with this stupid problem.
mastana , has got same problems with textbox.
I think it is a bug.
So I've used a listbox instead.
Try it out.
Use vbLf or vbCrLf instead of vbCr...
Instead of just putting vbCR at the end of the line use vbCrLf. This is carriage return line feed.
You can also use vbNewLine. Same as vbCrLf only easier to remember.
to move an object at runtime:
Text1(1).Move 100, 100
I have an access database with the structure:
Name(20)
Age(3)
Sex(1)
Address(50)
Now when I display the records in a text box, the data appears as:
mozart 20 M chvkhgodfgdfgds
beethoven 25 M ghkdfhghgkhgogjhohgfoh
Alex 18 M bfgkhkghljgjhogjho
Manish 23 M skdhfkhghgdg
How can I make this data appear symmetrical so that all the columns can fall in line and I can give proper column headings????
Try inserting a couple of vbTabs in between the columns. Better still, use a ListView control.
Set the font name of the text box to courier
When you fill the text box have a max for each field.
For example let say your first field can be a max of 20. You would add a string like this
text1 = left$(sfield + space$(20),20)
What this will do is always give a set length for the data that you would add. Just continue doing this for each field.