Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ausmoran
Starting Member
5 Posts |
 Posted - 2005-10-26 : 12:31:02
|
| I have a text box that is populated with several paragraphs of text into which I would like to inset several fields from a SQL database. I seem to be having a difficult time getting it to work. Can anybody give me a hand as to how to accomplish this? Every time I drag one of the field onto the text box, the paragraphs just disappear!Thanks in advance for any help you might offer!- Austin |
|
|
jhermiz
3564 Posts |
Posted - 2005-10-26 : 15:16:35
|
This is quite simple try this inside of a textbox or cell:="Hello field1's value is: " & Fields!YourField1.Value & " and the value of field2 is: " & Fields!YourField2.ValueEtc etc...just keep adding & as well as Fields!YourFieldNames.Valueas the fields in the database that are in your dataset.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
|
|
|
Adding Fields to a Text Box Question