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

Number field need * added before and after the number for barcode font

P: n/a
RC
I have a table with numbers in it. The table field is Long Integer
and the numbers are just consecutive 5 digit numbers, ie: 40000,
40001, 4002, 4003, etc. I place the table field (40001) in a text box
on a Report and then set the text box font to a barcode font (Code
39). BUT in order to read the barcode correctly the number in the
report (which produces the barcode) must have an asterisk before and
after the number, like, *40001*. I am creating and adding the numbers
to the table but I can't add them to a second field with asterisks
because I can't mix Text and Numbers. Any ideas?
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
To output the number with an asterisk on each side:

1. Open the report in design view.

2. Right-click the text box and choose Properties

3. Set the ControlSource to:
="*" & [Field1] & "*"

4. Change the Name property of the text box as well (Other tab of Properties
box).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"RC" <rc*********@yahoo.com> wrote in message
news:3c**************************@posting.google.c om...
I have a table with numbers in it. The table field is Long Integer
and the numbers are just consecutive 5 digit numbers, ie: 40000,
40001, 4002, 4003, etc. I place the table field (40001) in a text box
on a Report and then set the text box font to a barcode font (Code
39). BUT in order to read the barcode correctly the number in the
report (which produces the barcode) must have an asterisk before and
after the number, like, *40001*. I am creating and adding the numbers
to the table but I can't add them to a second field with asterisks
because I can't mix Text and Numbers. Any ideas?

Nov 13 '05 #2

P: n/a
RC
Problem solved. I used the Eval function to Evaluate the variable and
plugged the results of the Eval into a new variable that was declared
as String and then put that into a new column in the table where the
table field type was string.

rc*********@yahoo.com (RC) wrote in message news:<3c**************************@posting.google. com>...
I have a table with numbers in it. The table field is Long Integer
and the numbers are just consecutive 5 digit numbers, ie: 40000,
40001, 4002, 4003, etc. I place the table field (40001) in a text box
on a Report and then set the text box font to a barcode font (Code
39). BUT in order to read the barcode correctly the number in the
report (which produces the barcode) must have an asterisk before and
after the number, like, *40001*. I am creating and adding the numbers
to the table but I can't add them to a second field with asterisks
because I can't mix Text and Numbers. Any ideas?

Nov 13 '05 #3

P: n/a
rc*********@yahoo.com (RC) wrote in message news:<3c**************************@posting.google. com>...
I have a table with numbers in it. The table field is Long Integer
and the numbers are just consecutive 5 digit numbers, ie: 40000,
40001, 4002, 4003, etc. I place the table field (40001) in a text box
on a Report and then set the text box font to a barcode font (Code
39). BUT in order to read the barcode correctly the number in the
report (which produces the barcode) must have an asterisk before and
after the number, like, *40001*. I am creating and adding the numbers
to the table but I can't add them to a second field with asterisks
because I can't mix Text and Numbers. Any ideas?


how about putting an unbound textbox on your report and setting the
controlsource to "*" & [your_number_field] & "*"
Nov 13 '05 #4

P: n/a
RC
Thank you Allen and Pieter, I didn't check back quick enough before
wrote back with my "Eval" solution. I didn't know I could do that
with the control source. Your suggestion will be a much more elegant
solution. I won't have to clog up the table with an extra column of
data. Thanks for the lesson. RC

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<40***********************@freenews.iinet.net .au>...
To output the number with an asterisk on each side:

1. Open the report in design view.

2. Right-click the text box and choose Properties

3. Set the ControlSource to:
="*" & [Field1] & "*"

4. Change the Name property of the text box as well (Other tab of Properties
box).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"RC" <rc*********@yahoo.com> wrote in message
news:3c**************************@posting.google.c om...
I have a table with numbers in it. The table field is Long Integer
and the numbers are just consecutive 5 digit numbers, ie: 40000,
40001, 4002, 4003, etc. I place the table field (40001) in a text box
on a Report and then set the text box font to a barcode font (Code
39). BUT in order to read the barcode correctly the number in the
report (which produces the barcode) must have an asterisk before and
after the number, like, *40001*. I am creating and adding the numbers
to the table but I can't add them to a second field with asterisks
because I can't mix Text and Numbers. Any ideas?

Nov 13 '05 #5

P: n/a
RC
Thank you Allen and Pieter, I didn't check back quick enough before
wrote back with my "Eval" solution. I didn't know I could do that
with the control source. Your suggestion will be a much more elegant
solution. I won't have to clog up the table with an extra column of
data. Thanks for the lesson. RC

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<40***********************@freenews.iinet.net .au>...
To output the number with an asterisk on each side:

1. Open the report in design view.

2. Right-click the text box and choose Properties

3. Set the ControlSource to:
="*" & [Field1] & "*"

4. Change the Name property of the text box as well (Other tab of Properties
box).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"RC" <rc*********@yahoo.com> wrote in message
news:3c**************************@posting.google.c om...
I have a table with numbers in it. The table field is Long Integer
and the numbers are just consecutive 5 digit numbers, ie: 40000,
40001, 4002, 4003, etc. I place the table field (40001) in a text box
on a Report and then set the text box font to a barcode font (Code
39). BUT in order to read the barcode correctly the number in the
report (which produces the barcode) must have an asterisk before and
after the number, like, *40001*. I am creating and adding the numbers
to the table but I can't add them to a second field with asterisks
because I can't mix Text and Numbers. Any ideas?

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.