Peculiar behaviour of query

bluetongue

Registered User.
Local time
Today, 22:50
Joined
Jul 15, 2004
Messages
34
This is for information only - I am not seeking a solution.

I created a Select Query selecting only two memo fields from a single table.

The query works correctly unless you select Unique Values = Yes which results in the error message "The field is too small to accept the amount of data you attempted to add. Try inserting less data."
 
The UniqueValue property in a query works only when none of the fields in the query contains more than 254 characters.

^
 

Users who are viewing this thread

Back
Top Bottom