Recent content by i4004

  1. I

    Type mismatch with weekday function

    Made a third version, with the TempWeekDayNumber as Long and it all worked. Thank you for your help.
  2. I

    Type mismatch with weekday function

    Ah, I have just started afresh, new database file, new table, new form and the code worked. I then tried the next stage, to use the WeekDayName function to return the string name of the weekday integer. This stopped with a type mismatch error. Renamed my table field 'WeekDayName' (doh!) so...
  3. I

    Type mismatch with weekday function

    Renamed that 'Weekday' field - that didn't fix it though! tblTeachDay(TeachDayDate, WeekdayName, etc) TeachDayGenerateNewYear Form with tblTeachDay as record source. Controls on the form are the fields from the table, the command button to run the code and the inspection text box contro...
  4. I

    Type mismatch with weekday function

    Hi I have a calendar table which has a date field, 'TeachDay' and a weekday field 'Weekday'. I wish to write VBA code to add records for each new day and then to store the weekday (okay perhaps it should be calculated on the fly but I want to do this vba code). I have succeeded in adding...
  5. I

    Change txtBox font size depending on contents

    Thanks - I have used the OnFormat event of the detail section with an embedded macro. However, I could not find (nor in VBA) a font size property. Instead I have used two different txtBoxes, one with large font, one with small. I have then used conditions in the macros to find which one to...
  6. I

    Change txtBox font size depending on contents

    Any idea if it is possible to change the font size of a report text box according to it contents - in this case text which is either A or C? Conditional formatting does not appear to do more than change the style of font - I cannot see a text size option. Events do not appear to include...
See more
Top Bottom