Specifying the data type of a calculated column in a SELECT

You are not understanding my point, and I think it's because you're living in an Access-GUI-centric world. User access to queries (aka views) is not just via form or report. They can be accessed via ODBC for example, as I mentioned above, or via ResultSet in VBA. Neither one of those methods involves a form or a report. A datasheet doesn't involve a form or report either. It seems that you are the one getting hung up on display issues.

Thinking about this now, I could probably figure out what data type Access is assigning to the result set in VBA.

But let's just agree to disagree, or whatever.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom