• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 71
  • Last Modified:

Question about numeric and alpha caricatures when outputting?


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?
Earl Wolf
Earl Wolf
3 Solutions
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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.
Helen FeddemaCommented:
Column widthsIf the number is in the 1st column (it usually is), just make that column width 0 to hide it.
When you want to include the lookup value in your output, you must include a join to the lookup table and select the alpha value from there.

Select MainTable.CustID, MainTable.CustName, StateTable.StateName From MainTable Left Join StateTable
ON MainTableStateID = StateTable.StateID;

You can include the ID field or not depending on how you are using the query.  You will need the ID field ONLY if you are using the query as the RecordSource for a form or VBA procedure where StateID may need to be updated.
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>How do I change this to display Alpha instead of numeric?
Make sure the zero in the Data Widths is for the numeric, and make sure the Bound Column number is for the Alpha.
And as Pat illustrated above, make sure the Record Source SQL contains both columns.
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.
Earl WolfAuthor Commented:
thanks to all, I will see which issue it is. Either the comboBox or report
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now