Changing a value between a form and table

K

Katie

I have created a table with a corresponding form, and has a field with only a number in it. With the font used in the form (a bar code font), the characters in the number must change to show what I want. I need the number to look one way in the table, but as I go to the form, I need a program to run to split apart the number and assign each character a symbol based on its value, position, etc. I can use the Mid( ) function and a series of IfThen statements, but where else do I go? Can I turn the original number into an array to manipulate? How do I make the new string/array take the place of the old one?

Need clarification? Ask!

Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

color coding values 0
Data entry for a table from a form 1
Table Preferred width is changed when pasting 1
Change Form's Recordsource with SQL Statement? 0
Allow Temporary Edits In Form To Table Values 1
Not All Fields Update my Table from my Form 5
Lookup current record with ComboBox, any changes create new record 3
Pls Help - default value in a subform 1

Top