Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Versions des environnements
SQL Server:
SQL Server 2005
I will look into it. Thank you
>I'm thinking, that you can bring definitions of the numerical fields from SQL Server using Information_Schema.Columns view (the fields that participate in each particular form) and then compare juststem(ControlSource) against the cursor of such fields.
>
>>Thank you Naomi.
>>
>>At this point I am trying to figure out an efficient way to find the type of the control source of the field. The only way I know how to do it is to create an array using AFILED() and search for the particular field in the array for the size. But I am really hoping for something better. I guess, I can create a number of form array properties for each table I need to find the field type. Then in the gotfocus() of the textbox search for the type in the corresponding array and set the format accordingly.
>>
>>But I was hoping for something less "dramatic".
>>
>>
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement