Can I have multiple Fields in a combo box?

Anonymous
2024-12-20T20:35:10+00:00

If possible, what is proper Syntax to include two fields in a combo box?

I would like to see a Field for ItemNumber and Description.

Thank you!

Microsoft 365 and Office | Access | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

7 answers

Sort by: Most helpful
  1. Anonymous
    2024-12-20T22:14:18+00:00

    Sorry... quickly found I can, however, the data comes in plain text, and I need rich.

    As it happens my partner, who is an archivist, needed to display rich text in a 'citations' combo box in a database which she and I have been developing for a museum in the USA.  A combo box cannot in itself display rich text, but you can do so in a 'hybrid' control made up of a text box carefully superimposed on a combo box to appear and act like a single combo box control.  The text box is formatted as rich text, and this is what the user sees in the control while its list is not dropped down.  The underlying combo box is formatted as plain text, so the user selects a citation from another plain text column in the referenced table.  This column returns the first 255 characters of the citation, and is populated by code which strips out all of the rich text tags by means of multiple Replace function calls when a row is inserted into the Citations table.

    0 comments No comments
  2. Anonymous
    2024-12-20T22:26:40+00:00

    My Descriptions have special characters like: 1/2"

    Hi CDD_RTT,

    Rich text in this case is carrying to much cosmetics in an too early stage.

    Did you try CHR(189) & CHR(34) to expres 1/2" ?

    Imb.

    0 comments No comments