From what I recall, it had artwork and the story went as follows:
Boy aspires to be astronaut but when he's old enough he doesn't qualify
When he's older they start accepting everyone (except the elderly) and he's disqualified again.
Throughout his life his dreams keep evading him.
This short story was set in the future. I do recall there being robots as well. I think initially he wasn't qualified then they accepting everyone for manual labor/colonizing but he was to old to make the trip. I don't recall the main characters name unfortunately. I have a feeling it's an Asimov or Bradbury tale but I could be wrong.