Output only part of a field ( Text ) to a form control ?

[liamfitz]

I'd like to only output part of a field value to a Combo Box ( as it is, its control source, is set to this field ) The reason is, I have prefixed a single character a,b,c,or d - to the field's value, to ensure I sort the records in the order I want. However, I don't want or need the user, to see this 'control character. Any ideas please, much appreciated. Thanks.

 

[pbaldy]

I'm not clear on where you want it, but you can use the Mid() function to grab everything from the second character on. I typically use a separate field when I want to control the sorting of items in a combo.

 

[liamfitz]

Many thanks. I think that's what I'll do. Effectively create a second field, holding related letter codes, which I'll then sort on. There's a good site called 'Datapig.com' which provides video tutorials that seem helpful.

 

[pbaldy]

No problem.