Populate textBox

[Trinb37]

Hi,
Is there anyone out there who can help me with this problem? I am simply trying to display data from a table into a Texbox value. Using of course a query. This is what I have come up with so far:
Me.Text1 = Me.Text1 & "YourValue" & vbCrLf
I tried typing in the name of the fields and that is not working. I know that I can use a list box, but I much rather use a Text box so that I can take advantage of the text quality. I intend to display different fonts at a time in each line. Plus I like the look of the textBox. Someone please make my dream come true and show me how to do this. I am open to new concepts and techniques.
Thanks

James

 

[FoFa]

Like this?

 

[Trinb37]

Hi,
It's me again. I loved the idea that you gave me in that zip file. But I wanted to go a little further. I wanted the program to read the last row in the table and display the data of the last row in the table in a textbox value just like what you showed me, but the only differnce is that the user would not have to type in the information in a textbox. The user would then only have to click a form button and have the last line or row in the table be displayed in a text box.
Thanks again.
James

 

[FoFa]

OK, issues with that are, the last row in a table is never known. Data resides in a table in no known order. You may run a query or open a table and it appears in a certain order, but it most likely is not in that physical order in the table itself. That said, I am assuming you have a method to pick what you are calling the last row in a table. You could use dlookup (see help) to pull that last row, and do what you want with it. I just used a test box as an example in the file I had attached to the last post. You can substitue other means of obtaining the data rather than a text box.