Spaces in fields

[Slippenos]

Can I have field names with spaces ..

Example:

'Due Date'

It may not be good form, I'm trying to work with pre-existing data from an old employee.

-Thanks.

 

[PHV]

Yes, but it's not recommended.
Don't forget to use this syntax when referencing such a field: [Due Date]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RobSindle]

Yes, you can do it, but can get quite painful.
What I have done in the past is create a query for each table that translates old (bad format) names into new (good format) names. Then reference only the queries in my new code/forms/queries.

In query designer for field 'due date' just put in:

DueDate:[Due Date]

then use the query from there on out.
Works like a champ from then on out and doesn't mess with previous code.
HTH,
Rob

 

[Slippenos]

Good advice- thanks!