Create a uniform drop down list

[ipon70]

Hello,
I am looking to try and make all of the text line up better so that the drop downs looks more uniform.
Here is an example of what my issue is. All the lines by the first straight line start at different spots and makes it hard to read in a drop down.
The below data is from a concatenated list that will change at any moment in time.

BAILEY, ANGEL A | PHY-F | PAH | TLOD NO | HY YES | QRE YES

THOMISON, MATTHEW S | SPHY-M | PAH | TOLD YES | HY NO | QRE YES

MALKOW-DUNHAM, TAMMIE A | SPHY-F | PAH | TOLD NO | HY NO | QRE NO

JACOBSON II, MICHAEL G | PHY-M | PAH | TOLD YES | HY YES | QRE YES

CAVANAUGH, BRITTANY C | LPHY-F | PAL | TOLD NO | HY NO | QRE YES

What I would like it to look like, more like a straight line for the start and maybe the others also. Doesn't need this much space but you get the idea.

BAILEY, ANGEL A	| PHY-F	| PAH	| TLOD NO	| HY YES	| QRE YES
THOMISON, MATTHEW SS	| SPHY-M	| PAH	| TOLD YE	| HY NO	| QRE YES
MALKOW-DUNHAM, TAMMIE A	| SPHY-F	| PAH	| TOLD NO	| HY NO	| QRE NO
JACOBSON II, MICHAEL G	| PHY-M	| PAH	| TOLD YES	| HY YES	| QRE YES
CAVANAUGH, BRITTANY C	| LPHY-F	| PAL	| TOLD NO	| HY NO	| QRE YES

Hopefully that makes sense.

Thanks in advance

 

[ipon70]

Ok, how about

=IF(B2="","",CONCATENATE(Z2&REPT(" ",30-LEN(Z2))," | ",Q2," | ",R2," | ","TLOD ",S2," | ","HY ",T2," | ",IF(U2="","QRE NO","QRE "&U2)," | "))

and change the font to a mono-spaced font like courier.

Let me see if this works and I will post back, thank you so much for your help.

 

[Fluff]

Ok

 

[ipon70]

Let me see if this works and I will post back, thank you so much for your help.

Ok, how about

=IF(B2="","",CONCATENATE(Z2&REPT(" ",30-LEN(Z2))," | ",Q2," | ",R2," | ","TLOD ",S2," | ","HY ",T2," | ",IF(U2="","QRE NO","QRE "&U2)," | "))

and change the font to a mono-spaced font like courier.

Oh my lord, so the font was messing up the layout.....Here is the next question. Everything looks correct on all the sheets, but the in cell drop down list still isn't lined up. I have changed it to courier new as well, any ideas?

 

[Fluff]

You cannot change the font in a Form Control Combobox.

 

[ipon70]

You cannot change the font in a Form Control Combobox.

This is not the answer I wanted to hear.....yuck....well back to the drawing board.
Thank you so much for your help and thank you for taking time to get back to me.

 

[Fluff]

You could use an ActiveX control instead.

 

[ipon70]

You could use an ActiveX control instead.

Going to look into this and see if it would work. This would involve setting up 24X7 and that is a lot of boxes