Search results

Re: Handleing more than 255 characters of text ? Thank you for the reply, I understand that a common issue with memo fields is that with certain functions Access will truncate the field to the first 255 characters, will I encounter this if I use an Access front end with varchar SQL as a back...

Greetings all, I’m taking a filing index of City Council Resolutions which is currently based in Excel and transferring the index to an Access database I am building. An issue I am having is that the Resolutions being indexed have a “subject” description that ranges from about 100 characters...

As I mentioned, I'm new to expressions, I pieced it together and this works fine: =IIf([DeptAdmin]=True,"Administration ") & IIf([DeptCommSrvc]=True,"CommSrvc ") & IIf([DeptElect]=True,"Electri c") & IIf([DeptFin]=True,"Finance ") & IIf([DeptFire]=True,"Fire ") & IIf([DeptPolice]=True,"Police...

Thank you for the feedback, unfortuantely the fields are not mutually exclusive. At times there will be more than one field checked/designated as "True". I tweaked your expression and put this in a text box: =iif([DeptAdmin]=true,"Administration",iif([DeptCommSrvc]=true,"Community Service...

Greetings, I’m building a report [rptResoIndex] which contains 8 yes/no fields (check boxes). I started off working to get the report to only show the check boxes that are active/true and hide the check boxes that are not active/false. But as I was working towards this I realized I really don’t...