Link to home
Start Free TrialLog in
Avatar of Earl Wolf
Earl Wolf

asked on

Question about numeric and alpha caricatures when outputting?

Hi,

Is it possible to change the viewing, reporting and printing to see its Alpha setting instead? I created drop down menus from control boxes. The menus work well but when you view the data you see the numeric ID associated to it. Example, I created a drop down menu for US States. You select NJ as your choice. When you view or print, you see a 16 instead of NJ. I know the 16 is shown because it is NJ's numeric ID within the menu choices.

How do I change this to display Alpha instead of numeric?
Thanks
Earl
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Please give us a screen shot of what you're trying to pull off here, and specify if you are using Access Forms/Reports or SSRS.
ASKER CERTIFIED SOLUTION
Avatar of Helen Feddema
Helen Feddema
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Jim prompted me to reread the question.  If the problem is with the combobox itself, then Helen provided the answer.  You have to adjust the column widths.   If the problem is with a report or an export, then I provided the answer.
Avatar of Earl Wolf
Earl Wolf

ASKER

thanks to all, I will see which issue it is. Either the comboBox or report