Query to be displayed

[Trinb37]

Hi,
I have this one problem that I am looking in a new light that may help me to solve it after all. Well I have been trying to display from table into a texbox and was not successful at doing so nor even successful getting the right answer from anyone. Now, I think it would be best if I could just display from a query instead(I realized that I may have to do some calculation in the table and would have to use a query). Is displaying from a query into a textbox at all possible, and how can I go about doing that? Does anyone have any ideas concerning the matter... Can someone write an example of how to do so. I have come up with a example code on how to display into a textbox by just writing it in or possible using a string--I may be close. This is the code:

Me.Text1 = Me.Text1 & "YourValue" & vbCrLf

I would welcome any new ideas or modificaiton of the code example above. Thank you very much in advance.

~~~~~~~~~~~~~
James

 

[Tiro Cupidus]

If you're using that while looping through a recordset, it looks like it will work fine.

 

[Trinb37]

I there anyway you can give me an example in code so that I amy be able to apply it into what I am doing? This is a small step to what I want to achieve:
txtMyTextBox = "Pencil, .70" 'I want to this line to able to read from a query table.
txtMyTextBox.ForeColor = ??
txtMyTextBox.FontName = ??

Is there any way that this code can be modify?
Thanks you very much in advance.

~~~~~~~~~~~~~~~~
James