By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,570 Members | 1,724 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,570 IT Pros & Developers. It's quick & easy.

Format a Text Box

P: 1
I need some code help....If I wanted to tie a string of text to a text box along with a field in a table, how would I do it??

In other words the text box control source would be something like this


"Total Sales for Year" + & ([Ttlsales]) ????

I know the code is not right...that's why I am here!!
Feb 27 '08 #1
Share this Question
Share on Google+
2 Replies


JKing
Expert 100+
P: 1,206
I need some code help....If I wanted to tie a string of text to a text box along with a field in a table, how would I do it??

In other words the text box control source would be something like this


"Total Sales for Year" + & ([Ttlsales]) ????

I know the code is not right...that's why I am here!!
Hi there,

I suggest using a label control for the text "Total Sales for Year" then position it beside a bound text box control to the field [Ttlsales].

This can be accomplished by creating a new form based on a table/query of your choice. Then you can simply click and drag the field you want to the form. An accompanying label will also be created and you can just change the text of the label.

Hope this helps,

Jking
Feb 27 '08 #2

NeoPa
Expert Mod 15k+
P: 31,769
Alternatively, you could have a simple "bound" TextBox (called txtTtlSales) which is bound to the TtlSales field and HIDDEN. You could have another VISIBLE TextBox with a ControlSource of :
Expand|Select|Wrap|Line Numbers
  1. ="Total Sales for Year " & [txtTtlSales]
Feb 28 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.