how to convert number to text on the fly

[associates]

Hi,

I have a quick question here. I have a form that has a listbox, combobox, and other buttons. In the listbox, there are 4 columns. The first column shows studentID then followed by name, and so on. I have a combobox that is designed to filter the listbox. Because the studentID in the student table is of type autonumber, I come into trouble when putting a wildcard like '*'. For example in the combobox that filters by studentID, i run into problem if i put in 10* to get all records that started with 10.

I know that i can just change the type of studentID from autonumber to text, but it'd take time. So is there any other way of getting around this issue?

Thank you in advance and look forward to hearing from you

 

[formerTexan]

Use the Cstr() and Clng() functions to convert your autonumbers to a string and back to a long integer.

Cheers,
Bill

 

[TheAceMan1]

How are ya associates . . .

Add a [blue]custom field[/blue] to the query used as the [blue]RowSource[/blue] of the [blue]Listbox[/blue] . . .

[blue]strID:CStr([studentID])[/blue]

. . . and ping against the custom field instead!

See Ya! . . . . . .