I have a text box sourced by the "Description" field - I want to change it to show the Description, and a few spaces, then the project ID - nothing worked - in case the spaces thing was causing the problem (it shouldn't have been), I decided to eliminate the spaces just the description, followed by the ProjID

this did not work:


as a control source - why not ?

got an error message ?Error

Try renaming your field: Description is a reserved word, and you can have problems using reserved words for your own purposes.

For a comprehensive list of names to avoid (as well as a link to a free utility to check your application for compliance), see what Allen Browne has in Problem names and reserved words in Access

darn - I thought it might be !

Actually, I spoke too soon - you are right about the reserved word, but that wasn't the problem, or at least that didn't solve the problem - I'm surprised I've never had this problem before - another thing is that I can't call it "DESC," because a lot of my SQL says to sort by such-and-such field DESC


This post has been edited by bakersburg9: Apr 17 2012, 05:41 PM