Recent content by ND1994

New at this and in education. I would like to take letter grades from a grade field in my table and on a form I use for grade input, and create a new field which would appear as a score for that particular grade. So, If [Grade]=A+, 100, [Grade]= A, 90, etc. Probably an easy thing for most...

My undertsanding is that text fields are limited to 255 characters. A friend has a databse with some "notes" type fields with data a few sentences long. Is there any way around this limit. If not, what database recommendations can anyone make for someone who needs a questionnaire component in...

We do alot of find and replace in our main form (CTRL+F). The glitch is that once the pop-up box for "Find and Replace" appears, we almost always have to change the search setting from "Whole Field" to "Any Part of Field". Is there a way to set the default to "Any Part of Field" instead so...

I have written some expressions that now work fine for several fields in the main form that I use constantly. When someone asked me to print out a table today, I noticed that the fields in the table which are contingent upon formulas created in the properties of my main form are all blank. For...

Thanks! Your suggestion helped me fix it. Thanks for the guidance. I ended up writing this expression which works and it now seems so simple: IIf([Math Score]<30, "Standard", IIf([Math Score] Between 30 And 40,"Honors",Null))

I am just learning to build a simple access databse for an admission office that I run. I am learning access and simple vb just by doing. One snag I have run into while trying to get this thing up and running is with compound if statements (that's what I have been calling them anyway). I...