JennDub
Last Activity: Oct 14 '09, 08:14 PM
Joined: Oct 7 '09
Location: Virginia
-
The input mask actually upgrades any text entered into all caps using the ">" symbol. It would eliminate the need for a user to click the "Caps Lock". -
DanicaDear,
You could use an input mask such as ">aaaaa" in the text box "Input Mask" property. You would need to continue the a's above for as many characters as you would like to allow the user to enter.
~JennDubLeave a comment:
-
lolodede,
You could do this a couple of ways: either place the code to calculate the age group in an Event (On_Open for a continuous form displaying multiple records at once or On_Current if you are displaying one record at a time) to update the displayed value in "Age Group" or create a non-visible calculated field for each record (place the age calculation using System Date vs. DOB in it) and run the "Age Group" off...Leave a comment:
-
g diddy,
I think you're referencing the wrong field in your IIF statement. If you would like find out whether the data in one table (StudentID) exists in the other and display them as the calculated field named "Here", you might want to try to replace your IIF statement in the SQL with:
From your first...Code:IIf(IsNull([SpecialNeedsStudents].STUDENTID), "", "exists in database") AS Here
Leave a comment:
-
Function Missing Argument
g diddy,
I think that if you change your IIF statement to read:
the "wrong number of arguments" error will be resolved. When you started your "IsNull" criteria you began with a "(" but did not include an ending ")" after the field name. Once th IIF statement...Code:IIf(IsNull([SpecialNeedsStudents].Here), "", "exists in database")
Leave a comment:
No activity results to display
Leave a comment: