Convert Space to an Underscore

[ddrew]

Is it possible to convert a space to an underscore in a combobox. I need a naming convention within a combobox, at present some people use spaces and some people use underscore, I want underscore as the norm. The only reason for this is that in another program that is used we have to use underscore so it makes sense that they are the same!

 

[DCrake]

Simple Software Solutions

On the AfterUpdate or OnChange or LostFocus of a control

Use the following command

Me.ActiveControl = Replace(Me.ActiveControl," ","_")

This will replace all instances of a Space to and underscore.

CodeMaster:http://www.icraftlimited.co.uk

 

[missinglinq]

You can use the Replace() function to do this in the SQL used by your RowSource for your combobox.

I tested this on a combobox. My original statement was this

SELECT UtilityTable.NName FROM UtilityTable ORDER BY [NName];

I modified the statement to this

SELECT Replace(UtilityTable.NName," ","_") FROM UtilityTable ORDER BY [NName];

and got the results you want, while retaining full functionality of the combobox.

 

[ddrew]

Thanks guys, spot on!