Generate records based on a given number range

[Fiaz Idris]

I am an access newbie and I have the following question.

Say, There is a text box in a form for input a number range and
the user inputs the following.

TextBox: AA123453,57-59,500,505-507,556

I wish to add the following 9 records to the table.

AA123453
AA123457
AA123458
AA123459
AA123500
AA123505
AA123506
AA123507
AA123556

This saves time for the user when there are lots of such numbers
to be input for e.g. 505-550, etc.

Could someone tell me how I might go about in doing this?
Is programming the only option? and if yes, how?

Anyone else had to use such a feature in their db. How did you
go about implementing it?

Thanks.